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

insert into xueshengxinxi(xuehao,mima,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng,zhaopian,beizhu) values('010','001','胡歌','男','13544655202','56547474@qq.com','33032718501209','upload/nopic.jpg','暂无');
insert into xueshengxinxi(xuehao,mima,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng,zhaopian,beizhu) values('032','001','滕少华','男','13587835380','regrodd@qq.com','330327198615482633','upload/nopic.jpg','abc');
insert into xueshengxinxi(xuehao,mima,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng,zhaopian,beizhu) values('003','001','冯子杰','男','13623256544','2352352@qq.com','33032718650304','upload/nopic.jpg','ok');
insert into xueshengxinxi(xuehao,mima,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng,zhaopian,beizhu) values('029','001','郑亚斌','男','13910215489','43643933@qq.com','33032719900723568X','upload/nopic.jpg','暂无');
insert into xueshengxinxi(xuehao,mima,xueshengxingming,xingbie,shouji,youxiang,shenfenzheng,zhaopian,beizhu) values('001','001','邱建彰','男','18956482221','	fegge@163.com','330327199010142546','upload/nopic.jpg','abc');