一.创建相应的表
1）创建一张学生信息的表，包含 id（自增），学号，姓名，性别，身高，体重，备注
CREATE TABLE t_student ( id int(25) PRIMARY KEY auto_increment, number int(25) UNIQUE not null, name varchar(25) not null , gender varchar(9) not null, height int(25) default 0, weight int(25) default 0, comment varchar(9) default \' \' ); insert into t_student values(null,2018001,\'李四\',\'男\',167,50,\'\'); insert into t_student values(null,2018002,\'李内\',\'男\',173,58,\'\'); insert into t_student values(null,2018003,\'蒙牛\',\'男\',172,70,\'\');