![`#############mysql数据库创建语句###################
create table t_admin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘超级管理员账号’,
password varchar(100) comment ‘超级管理员密码’
) comment ‘超级管理员’;
insert into t_admin(username,password) values(‘admin’,‘123456’);
create table t_cgrk(
id int primary key auto_increment comment ‘主键’,
types varchar(100) comment ‘物品’,
jg int(11) comment ‘价格’,
sl int(11) comment ‘数量’,
zj int(11) comment ‘总价’,
gg varchar(100) comment ‘规格’,
rq datetime comment ‘日期’
) comment ‘采购入库’;
create table t_student(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘学号’,
password varchar(100) comment ‘密码’,
studentName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
address varchar(100) comment ‘地址’<