zuoyefabu.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

SET character_set_client = gb2312; 
SET character_set_connection = gb2312; 
SET character_set_database = gb2312; 
SET character_set_results = gb2312; 
SET character_set_server = gb2312;
CREATE TABLE `zuoyefabu` (
   `id` int(11) not null auto_increment,
   `zuoyebianhao` varchar(50),`zuoyebiaoti` varchar(50),`leixing` varchar(50),`zuoyeneirong` varchar(500),`jiezhishijian` datetime,`banjima` varchar(50),`banji` varchar(50),`issh` varchar(10) DEFAULT '否',
   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2;

insert into zuoyefabu(zuoyebianhao,zuoyebiaoti,leixing,zuoyeneirong,jiezhishijian,banjima,banji) select '381424249','苍南县2012招聘中小学（幼儿园）教师理论考试成绩公布','班级作业','','2019-4-2 04:02:00',banjima,banji from banjixinxi order by rand()  limit 0,1;
insert into zuoyefabu(zuoyebianhao,zuoyebiaoti,leixing,zuoyeneirong,jiezhishijian,banjima,banji) select '381424249','温州质检院搬新家 分为东西两区','班级作业','','2019-4-1 08:35:00',banjima,banji from banjixinxi order by rand()  limit 0,1;
insert into zuoyefabu(zuoyebianhao,zuoyebiaoti,leixing,zuoyeneirong,jiezhishijian,banjima,banji) select '381436005','海峡银行温州分行正式对外营业','班级作业','','2019-2-24 15:49:00',banjima,banji from banjixinxi order by rand()  limit 0,1;
insert into zuoyefabu(zuoyebianhao,zuoyebiaoti,leixing,zuoyeneirong,jiezhishijian,banjima,banji) select '381424249','苍南县2012招聘中小学（幼儿园）教师理论考试成绩公布','小组作业','','2019-3-10 00:35:00',banjima,banji from banjixinxi order by rand()  limit 0,1;
insert into zuoyefabu(zuoyebianhao,zuoyebiaoti,leixing,zuoyeneirong,jiezhishijian,banjima,banji) select '381436005','温州质检院搬新家 分为东西两区','小组作业','','2019-4-1 08:35:00',banjima,banji from banjixinxi order by rand()  limit 0,1;

update zuoyefabu set issh='是';