create database tongxunlu default charset utf8;
use tongxunlu;
create table yonghu(
id int primary key auto_increment,
xingming varchar(20) not null,
mima varchar(20) not null,
xuehao varchar(20) not null,
zhiwu varchar(20) not null,
xingbie varchar(10) not null,
dianhua varchar(11) not null,
qq varchar(20) not null,
email varchar(100) not null,
shengri date not null,
banji_id int
);
insert into yonghu values
(null,'zhangsan','123456','1001','学生','男','13362525004','191544487','191544487@qq.com','2013-5-5',2),
(null,'zhangshi','123456','1002','学生','男','13213','1232132','33544487@qq.com','2013-5-5',2),
(null,'wangwu','123456','1003','学生','男','123213','12321','44544487@qq.com','2013-5-5',2);
create table banji(
id int primary key auto_increment,
banming varchar(20) not null
);
insert into banji values
(null,'软件171'),
(null,'软件172'),
(null,'软件173'),
(null,'会计171'),
(null,'会计172'),
(null,'会计173'),
(null,'会计174');