- create table Categories
- (
- categoryId int(10) auto_increment not null primary key,
- categoryName varchar(30),
- description varchar(100),
- parentId int
- )
- insert into Categories values(1,'电脑','关于电脑',0);
- insert into Categories values(2,'电视机','关于电视机',0);
- insert into Categories values(3,'数码相机','关于数码相机',0);
- insert into Categories values(4,'冰箱','关于冰箱',0);
- insert into Categories values(5,'联想电脑','关于联想电脑',1);
- insert into Categories values(6,'创维电视机','关于创维电视机',2);
- insert into Categories values(7,'索尼相机','关于索尼相机',3);
- insert into Categories values(8,'海尔冰箱','关于海尔冰箱',4);
- insert into Categories values(9,'旭日电脑','关于旭日电脑',5);
- insert into Categories values(10,'天逸电脑','关于天逸电脑',5);
- insert into Categories values(11,'创维液晶电视','关于创维液晶电视机',6);
- insert into Categories values(12,'索尼M23相机','关于索尼M23相机',7);
- insert into Categories values(13,'海尔G1冰箱','关于海尔G1冰箱',8);