insert into likecate (id,path,catename,cateorder,createtime) values
(1,'','手机',0,0),
(2,'1','功能手机',0,0),
(3,'1,2','老人手机',0,0),
(4,'1,2','儿童手机',0,0),
(5,'1','智能手机',0,0),
(6,'1,5','android手机',0,0),
(7,'1,5','IOS手机',0,0),
(8,'1,5','WinPhote手机',0,0),
(9,'1,2,4','色盲手机',0,0),
(10,'1,2,3','大字手机',0,0)
;
(1,'','手机',0,0),
(2,'1','功能手机',0,0),
(3,'1,2','老人手机',0,0),
(4,'1,2','儿童手机',0,0),
(5,'1','智能手机',0,0),
(6,'1,5','android手机',0,0),
(7,'1,5','IOS手机',0,0),
(8,'1,5','WinPhote手机',0,0),
(9,'1,2,4','色盲手机',0,0),
(10,'1,2,3','大字手机',0,0)
;
2016-05-05
表单数据:
insert into fenlei(id,pid,catename,cateorder,createtime) values
(1,0,'新闻',0,0),
(2,0,'图片',0,0),
(3,1,'国内新闻',0,0),
(4,1,'国际新闻',0,0),
(5,3,'北京新闻',0,0),
(6,4,'美国新闻',0,0),
(7,2,'美女图片',0,0),
(8,2,'风景图片',0,0),
(9,7,'日韩明星',0,0),
(10,9,'大陆明星',0,0);
insert into fenlei(id,pid,catename,cateorder,createtime) values
(1,0,'新闻',0,0),
(2,0,'图片',0,0),
(3,1,'国内新闻',0,0),
(4,1,'国际新闻',0,0),
(5,3,'北京新闻',0,0),
(6,4,'美国新闻',0,0),
(7,2,'美女图片',0,0),
(8,2,'风景图片',0,0),
(9,7,'日韩明星',0,0),
(10,9,'大陆明星',0,0);
2016-04-14
创建表: create table fenlei(
id int unsigned not null auto_increment primary key,
pid int unsigned not null,
catename varchar(30) not null,
cateorder int unsigned not null,
createtime int(10) not null
);
id int unsigned not null auto_increment primary key,
pid int unsigned not null,
catename varchar(30) not null,
cateorder int unsigned not null,
createtime int(10) not null
);
2016-04-14
代码无法插入???
INSERT INTO 'deepcate'(`id`, `pid`, `catename`, `cateorder`, `createtime`)VALUES
(1,0,"新闻",0,0),
(1,0,'新闻',0,0),
(2,0,'图片',0,0),
(3,1,'国内新闻',0,0),
(4,1,'国际新闻',0,0),
(5,3,'北京新闻',0,0),
(6,4,'美国新闻',0,0),
(7,2,'美女图片',0,0),
(8,2,'风景图片',0,0),
(9,7,'日韩明星',0,0),
(9,9,'日本AV',0,0);
INSERT INTO 'deepcate'(`id`, `pid`, `catename`, `cateorder`, `createtime`)VALUES
(1,0,"新闻",0,0),
(1,0,'新闻',0,0),
(2,0,'图片',0,0),
(3,1,'国内新闻',0,0),
(4,1,'国际新闻',0,0),
(5,3,'北京新闻',0,0),
(6,4,'美国新闻',0,0),
(7,2,'美女图片',0,0),
(8,2,'风景图片',0,0),
(9,7,'日韩明星',0,0),
(9,9,'日本AV',0,0);
2016-02-11