yuangongxinxi.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 `yuangongxinxi` (
   `id` int(11) not null auto_increment,
   `gonghao` varchar(50),`mima` varchar(50),`xingming` varchar(50),`xingbie` varchar(50),`bumen` varchar(50),`zhiwu` varchar(50),`ruzhishijian` date,`dianhua` varchar(50),`beizhu` varchar(500),`issh` varchar(10) DEFAULT '否',
   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2;

insert into yuangongxinxi(gonghao,mima,xingming,xingbie,bumen,zhiwu,ruzhishijian,dianhua,beizhu) select '020','001','贾静雯','女',bumen,'销售员','2019-4-7','17706641413','ok' from bumenxinxi order by rand()  limit 0,1;
insert into yuangongxinxi(gonghao,mima,xingming,xingbie,bumen,zhiwu,ruzhishijian,dianhua,beizhu) select '028','001','李鹏','男',bumen,'快递员','2019-4-7','13748589658','暂无' from bumenxinxi order by rand()  limit 0,1;
insert into yuangongxinxi(gonghao,mima,xingming,xingbie,bumen,zhiwu,ruzhishijian,dianhua,beizhu) select '007','001','官小芝','女',bumen,'秘书','2019-4-1','13159863241','ok' from bumenxinxi order by rand()  limit 0,1;
insert into yuangongxinxi(gonghao,mima,xingming,xingbie,bumen,zhiwu,ruzhishijian,dianhua,beizhu) select '013','001','周盛','女',bumen,'导游','2019-4-1','13052154877','无' from bumenxinxi order by rand()  limit 0,1;
insert into yuangongxinxi(gonghao,mima,xingming,xingbie,bumen,zhiwu,ruzhishijian,dianhua,beizhu) select '001','001','邱建彰','男',bumen,'主持人','2019-4-1','13587835380','abc' from bumenxinxi order by rand()  limit 0,1;

update yuangongxinxi set issh='是';