求MYSQL5.0 父子关系的SQL语句(200分)

表结构：<br>ID &nbsp;varchar 10 &nbsp;<br>PID varchar 10<br>NAME VARCHAR 100<br><br>求在MYSQL下实现的SQL语句。<br>本人对MYSQL实在是不熟悉。<br><br>谢谢。l

不懂什么意思

PID varchar 10 大概是个外键吧<br><br>Create Table p(<br>ID &nbsp;int AUTO_Increasment , <br>NAME VARCHAR 100,<br>primary key(ID),<br>)<br><br>Create Table child(<br>ID &nbsp;int AUTO_Increasment , <br>PID varchar 10,<br>NAME VARCHAR 100,<br>foreign key PID reference P(ID),<br>primary key(ID)<br>)

我刚才看了三个SQL语句的问题,都是没有把问题说清楚的,你到底是要数据呢还是要建表?

现在已经有了这个表，现在需要随便输入一个ID，就把这个ID及其子ID都取出来。希望得到这样的sql语句。<br>没有把问题说清楚，请包涵，谢谢各位了。

MYSQL?如果只是有SQL语句的话，那就要用到存储过程了。不晓得MYSQL5支持与否。<br>并且是递归调用存储过程，复杂了点。。。<br>建议在存储过程中不要用游标，因为一是速度问题，二是递归调用游标不可再定义，用临时表还可以。。。<br>MYSQL的系统函数不大懂，只能有这点建议了。。。。

只能告诉你,你这样子的表格设计,要用到存储过程了,不过我用的是mysql 4.1<br>我个人建议你建无限分类的表使用以下的格式:<br>ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PList<br>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 分类一 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0<br>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 分类二 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,1<br>3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 分类三 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,1,2<br>4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 分类四 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,1<br><br>建无限分类的表有很多种,我一般在用的是上面这种,只要取出Plist马上就可以取得相应的分类列表了.

thanks