使用语句插入频道，这样添加的频道拥有出厂id
本帖最后由 liuyan 于 2013-10-24 11:40 编辑备注啊：执行前，先看看 将要执行的语句里面的id是否存在，如果存在的话，就不适用了，千万别执行。
INSERT INTO job_channel VALUES('1','找工作','简历','简历','找工作','个人求职','个人求职','0','0','0','','person','1','0','1','1','0','0','0','0');
INSERT INTO job_channel VALUES('2','招人才','职位','职位','招人才','企业招聘','企业招聘','1','0','0','','company','2','0','1','1','0','0','0','0');
INSERT INTO job_channel VALUES('3','院校','院校','院校','院校联盟','院校联盟','院校联盟','2','0','0','','school','3','0','1','0','0','0','0','0');
INSERT INTO job_channel VALUES('4','猎头','猎头','猎头','猎头服务','猎头服务','猎头服务','3','0','0','','hr','4','0','1','0','0','0','0','0');
INSERT INTO job_channel VALUES('5','培训','培训','培训','教育培训','教育培训','教育培训','5','0','0','','train','5','0','1','0','0','0','0','0');
INSERT INTO job_channel VALUES('6','资讯','新闻','新闻','人力资讯','人力资讯','人力资讯','6','0','0','','article','10','0','1','1','0','0','2','0');
INSERT INTO job_channel VALUES('7','高级人才','人才','人才','高级人才','高级人才','高级人才','7','0','0','','besthr','1','0','1','1','0','0','0','0');
INSERT INTO job_channel VALUES('8','兼职人才','人才','人才','兼职人才','兼职人才','兼职人才','8','0','0','','sideline','1','0','1','1','0','0','0','0');
INSERT INTO job_channel VALUES('9','常见问题','帮助','帮助','常见问题','常见问题','常见问题','9','0','0','','help','14','0','1','1','0','0','0','0');
INSERT INTO job_channel VALUES('10','留言反馈','留言','留言','留言反馈','留言反馈','留言反馈','10','0','0','','guestbook','6','0','1','1','0','0','0','0');
INSERT INTO job_channel VALUES('11','微招聘','','','微招聘,一句话招聘','','','13','0','2','/vhire/','','0','0','1','0','0','0','0','0');
INSERT INTO job_channel VALUES('12','现场招聘','','','现场招聘会','','','13','0','2','/zph/','','0','0','1','0','0','0','0','0');
INSERT INTO job_channel VALUES('13','地图招聘','','','地图招聘','','','14','0','2','/search/map_search.php','','0','1','1','0','0','0','0','0');
出厂ID，如果出厂ID被占用的话，是会出错的。 备注啊：执行前，先看看 将要执行的语句里面的id是否存在，如果存在的话，就不适用了。
页:
[1]