56,678
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE a (
`id` int(100) NOT NULL ,
`name` varchar(20) NULL ,
`pid` int NULL
);
INSERT into a VALUE (1,'父类1',null);
INSERT into a VALUE (2,'父类2',null);
INSERT into a VALUE (3,'子类1',1);
INSERT into a VALUE (4,'子类2',1);
INSERT into a VALUE (5,'子类3',2);
INSERT into a VALUE (6,'子类4',3);