insertvalues.sql

一个网上购物商城系统

use xindou;
insert into category(cname,parentid,description,ctype) values ('包包',0,'包包',1);
insert into category(cname,parentid,description,ctype) values ('电脑产品',0,'电脑产品',1);
insert into category(cname,parentid,description,ctype) values ('数码娱乐',0,'数码娱乐',1);
insert into category(cname,parentid,description,ctype) values ('办公家居',0,'办公家居',1);
insert into category(cname,parentid,description,ctype) values ('苹果专区',0,'苹果专区',1);
insert into category(cname,parentid,description,ctype) values ('礼品团购区',0,'礼品团购区',1);

insert into category(cname,parentid,description,ctype) values ('手提包',1,'手提包',2);
insert into category(cname,parentid,description,ctype) values ('背包',1,'背包',2);
insert into category(cname,parentid,description,ctype) values ('旅行箱包',1,'旅行箱包',2);
insert into category(cname,parentid,description,ctype) values ('笔记本内袋',1,'笔记本内袋',2);
insert into category(cname,parentid,description,ctype) values ('数码包',1,'数码包',2);
insert into category(cname,parentid,description,ctype) values ('休闲包',1,'休闲包',2);
insert into category(cname,parentid,description,ctype) values ('多功能包',1,'多功能包',2);

insert into category(cname,parentid,description,ctype) values ('存储设备',2,'存储设备',2);
insert into category(cname,parentid,description,ctype) values ('笔记本及周边',2,'笔记本及周边',2);
insert into category(cname,parentid,description,ctype) values ('输入输出设备',2,'输入输出设备',2);
insert into category(cname,parentid,description,ctype) values ('接口设备',2,'接口设备',2);
insert into category(cname,parentid,description,ctype) values ('线材类',2,'线材类',2);
insert into category(cname,parentid,description,ctype) values ('音频/视频设备',2,'音频/视频设备',2);
insert into category(cname,parentid,description,ctype) values ('电源设备',2,'电源设备',2);
insert into category(cname,parentid,description,ctype) values ('网络设备',2,'网络设备',2);

insert into category(cname,parentid,description,ctype) values ('GPS设备',3,'GPS设备',2);
insert into category(cname,parentid,description,ctype) values ('车载电子',3,'车载电子',2);
insert into category(cname,parentid,description,ctype) values ('影音设备',3,'影音设备',2);
insert into category(cname,parentid,description,ctype) values ('游戏玩具',3,'游戏玩具',2);
insert into category(cname,parentid,description,ctype) values ('手机通讯',3,'手机通讯',2);
insert into category(cname,parentid,description,ctype) values ('数码存储',3,'数码存储',2);
insert into category(cname,parentid,description,ctype) values ('数码周边配件',3,'数码周边配件',2);

insert into category(cname,parentid,description,ctype) values ('办公设备',4,'办公设备',2);
insert into category(cname,parentid,description,ctype) values ('办公周边及耗材',4,'办公周边及耗材',2);
insert into category(cname,parentid,description,ctype) values ('小家电',4,'小家电',2);

insert into category(cname,parentid,description,ctype) values ('苹果iPhone专区',5,'苹果iPhone专区',2);
insert into category(cname,parentid,description,ctype) values ('苹果iPod专区',5,'苹果iPod专区',2);
insert into category(cname,parentid,description,ctype) values ('苹果电脑',5,'苹果电脑',2);

insert into category(cname,parentid,description,ctype) values ('小家电',6,'小家电',2);
insert into category(cname,parentid,description,ctype) values ('家居用品',6,'家居用品',2);


insert into category(cname,parentid,description,ctype) values ('男式电脑包',7,'男式电脑包',3);
insert into category(cname,parentid,description,ctype) values ('女式电脑包',7,'女式电脑包',3);
insert into category(cname,parentid,description,ctype) values ('手提式内袋',7,'手提式内袋',3);

insert into category(cname,parentid,description,ctype) values ('男式电脑背包',8,'男式电脑背包',3);
insert into category(cname,parentid,description,ctype) values ('女式电脑背包',8,'女式电脑背包',3);
insert into category(cname,parentid,description,ctype) values ('拉杆背包',8,'拉杆背包',3);
insert into category(cname,parentid,description,ctype) values ('休闲运动背包',8,'休闲运动背包',3);

insert into category(cname,parentid,description,ctype) values ('旅行包',9,'旅行包',3);
insert into category(cname,parentid,description,ctype) values ('拉杆箱包',9,'拉杆箱包',3);
insert into category(cname,parentid,description,ctype) values ('证件袋/钱包',9,'证件袋/钱包',3);
insert into category(cname,parentid,description,ctype) values ('旅行盥洗包',9,'旅行盥洗包',3);

insert into category(cname,parentid,description,ctype) values ('手提式内袋',10,'手提式内袋',3);
insert into category(cname,parentid,description,ctype) values ('普通内袋',10,'普通内袋',3);

insert into category(cname,parentid,description,ctype) values ('双肩摄影包',11,'双肩摄影包',3);
insert into category(cname,parentid,description,ctype) values ('数码相机/摄像机包',11,'数码相机/摄像机包',3);
insert into category(cname,parentid,description,ctype) values ('数码便携包',11,'数码便携包',3);
insert into category(cname,parentid,description,ctype) values ('CD包/盒',11,'CD包/盒',3);

insert into category(cname,parentid,description,ctype) values ('休闲挎包',12,'休闲挎包',3);
insert into category(cname,parentid,description,ctype) values ('休闲腰包',12,'休闲腰包',3);
insert into category(cname,parentid,description,ctype) values ('休闲单肩包',12,'休闲单肩包',3);
insert into category(cname,parentid,description,ctype) values ('休闲双肩背包',12,'休闲双肩背包',3);

insert into category(cname,parentid,description,ctype) values ('车载用包',13,'车载用包',3);

insert into category(cname,parentid,description,ctype) values ('U盘',14,'U盘',3);
insert into category(cname,parentid,description,ctype) values ('硬盘',14,'硬盘',3);
insert into category(cname,parentid,description,ctype) values ('光盘',14,'光盘',3);
insert into category(cname,parentid,description,ctype) values ('闪存卡',14,'闪存卡',3);
insert into category(cname,parentid,description,ctype) values ('外置盒',14,'外置盒',3);
insert into category(cname,parentid,description,ctype) values ('移动硬盘',14,'移动硬盘',3);
insert into category(cname,parentid,description,ctype) values ('网络硬盘',14,'网络硬盘',3);
insert into category(cname,parentid,description,ctype) values ('磁盘阵列',14,'磁盘阵列',3);
insert into category(cname,parentid,description,ctype) values ('数据磁带',14,'数据磁带',3);
insert into category(cname,parentid,description,ctype) values ('硬盘抽取盒/模组',14,'硬盘抽取盒/模组',3);

insert into category(cname,parentid,description,ctype) values ('迷你笔记本电脑',15,'迷你笔记本电脑',3);
insert into category(cname,parentid,description,ctype) values ('品牌原装配件',15,'品牌原装配件',3);

insert into category(cname,parentid,description,ctype) values ('键盘鼠标',16,'键盘鼠标',3);
insert into category(cname,parentid,description,ctype) values ('鼠标垫/护腕垫',16,'鼠标垫/护腕垫',3);

insert into category(cname,parentid,description,ctype) values ('接口卡',17,'接口卡',3);
insert into category(cname,parentid,description,ctype) values ('USB集线器',17,'USB集线器',3);

insert into category(cname,parentid,description,ctype) values ('USB/1394线',18,'USB/1394线',3);
insert into category(cname,parentid,description,ctype) values ('网络/电话线',18,'网络/电话线',3);

insert into category(cname,parentid,description,ctype) values ('耳机耳麦',19,'耳机耳麦',3);
insert into category(cname,parentid,description,ctype) values ('音响',19,'音响',3);

insert into category(cname,parentid,description,ctype) values ('电源插座',20,'电源插座',3);
insert into category(cname,parentid,description,ctype) values ('变压器',20,'变压器',3);

insert into category(cname,parentid,description,ctype) values ('宽带路由器',21,'宽带路由器',3);
insert into category(cname,parentid,description,ctype) values ('网卡',21,'网卡',3);

insert into category(cname,parentid,description,ctype) values ('车载GPS导航',22,'车载GPS导航',3);
insert into category(cname,parentid,description,ctype) values ('手持GPS导航',22,'手持GPS导航',3);

insert into category(cname,parentid,description,ctype) values ('车载交流供电器',23,'车载交流供电器',3);

insert into category(cname,parentid,description,ctype) values ('MP3/MP4播放器',24,'MP3/MP4播放器',3);

insert into category(cname,parentid,description,ctype) values ('电子宠物',25,'电子宠物',3);

insert into category(cname,parentid,description,ctype) values ('手机配件大全',26,'手机配件大全',3);

insert into category(cname,parentid,description,ctype) values ('闪存卡',27,'闪存卡',3);

insert into category(cname,parentid,description,ctype) values ('三脚架',28,'三脚架',3);

insert into category(cname,parentid,description,ctype) values ('多功能一体机',29,'多功能一体机架',3);

insert into category(cname,parentid,description,ctype) values ('多媒体演讲器',30,'多媒体演讲器',3);

insert into category(cname,parentid,description,ctype) values ('空气净化器',31,'空气净化器',3);

insert into category(cname,parentid,description,ctype) values ('iPhone3G手机',32,'iPhone3G手机',3);

insert into category(cname,parentid,description,ctype) values ('苹果iPod播放器',33,'苹果iPod播放器',3);

insert into category(cname,parentid,description,ctype) values ('苹果笔记本电脑',34,'苹果笔记本电脑',3);

insert into category(cname,parentid,description,ctype) values ('电子玩具',35,'电子玩具',3);