jiarubanji.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 `jiarubanji` (
   `id` int(11) not null auto_increment,
   `banjima` varchar(50),`banji` varchar(50),`xuehao` varchar(50),`xueshengxingming` varchar(50),`xingbie` varchar(50),`shouji` varchar(50),`youxiang` varchar(50),`shenfenzheng` varchar(50),
   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2;

insert into jiarubanji(banjima,banji,xuehao,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng) select banjima,banji,'018','方之明','女','13159863241','grhtrhk@163.com','33032718501209' from banjixinxi order by rand()  limit 0,1;
insert into jiarubanji(banjima,banji,xuehao,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng) select banjima,banji,'019','梅邹雁','女','13623256544','regrodd@qq.com','330327198615482633' from banjixinxi order by rand()  limit 0,1;
insert into jiarubanji(banjima,banji,xuehao,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng) select banjima,banji,'016','郭家顺','男','13587835380','grorti@qq.com','330327199010142546' from banjixinxi order by rand()  limit 0,1;
insert into jiarubanji(banjima,banji,xuehao,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng) select banjima,banji,'009','赵姿吟','女','13184865998','trodd@yahoo.com','33032718650304' from banjixinxi order by rand()  limit 0,1;
insert into jiarubanji(banjima,banji,xuehao,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng) select banjima,banji,'001','杨颖','女','13769548711','2352352@qq.com','33032719900723568X' from banjixinxi order by rand()  limit 0,1;