![`#############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 ‘密码’