fafangshenqing.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 `fafangshenqing` (
   `id` int(11) not null auto_increment,
   `bianhao` varchar(50),`mingcheng` varchar(50),`kucun` varchar(50),`shenqingshuliang` varchar(50),`shenqingliyou` varchar(50),`riqi` date,`gonghao` varchar(50),`xingming` varchar(50),`bumen` varchar(50),`fafangzhuangtai` varchar(50),`huifuyijian` varchar(500),
   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2;

insert into fafangshenqing(bianhao,mingcheng,kucun,shenqingshuliang,shenqingliyou,riqi,gonghao,xingming,bumen) select bianhao,mingcheng,kucun,'27','','2019-4-10','016','郭依洁','售后部' from diannaoxinxi order by rand()  limit 0,1;
insert into fafangshenqing(bianhao,mingcheng,kucun,shenqingshuliang,shenqingliyou,riqi,gonghao,xingming,bumen) select bianhao,mingcheng,kucun,'95','','2019-4-20','024','邓超','财务部' from diannaoxinxi order by rand()  limit 0,1;
insert into fafangshenqing(bianhao,mingcheng,kucun,shenqingshuliang,shenqingliyou,riqi,gonghao,xingming,bumen) select bianhao,mingcheng,kucun,'95','','2019-4-21','034','陈明希','技术部' from diannaoxinxi order by rand()  limit 0,1;
insert into fafangshenqing(bianhao,mingcheng,kucun,shenqingshuliang,shenqingliyou,riqi,gonghao,xingming,bumen) select bianhao,mingcheng,kucun,'95','','2019-4-21','023','袁庆轩','人事部' from diannaoxinxi order by rand()  limit 0,1;
insert into fafangshenqing(bianhao,mingcheng,kucun,shenqingshuliang,shenqingliyou,riqi,gonghao,xingming,bumen) select bianhao,mingcheng,kucun,'62','','2019-4-14','001','穆铁柱','销售部' from diannaoxinxi order by rand()  limit 0,1;