Mysql_可恶的王晓林

drop table if exists student;
create table student(
stuid char(10) not null comment'学号',
stuname char(10) not null comment'姓名',
stusex char(2) not null comment'性别',
studate date comment'出生日期',
address varchar(20) comment'地区',
stumz char(10) comment'民族',
classid char(6) comment'班级编号'
);
SELECT*FROM student;
-- INSERT INTO student VALUES('502001','王晓林','男','2000-02-10','广东','汉','IS2020');
INSERT INTO student VALUES('2013310103','黄菊','女','1995-09-30','北京','汉','IS1301');
INSERT INTO student VALUES('2013110103','王一敏','女','1998-01-01','河北','汉','AC1301');

UPDATE student SET stuid='502001',stuname='王晓林',stusex='男',studate='2000-02-10',address='广东',stumz='汉',classid='IS2020';
UPDATE student SET studate='1998-02-10',classid='AC1302'WHERE stuname='王一敏';
UPDATE student SET address =CONCAT(address,'省或市');
delete from student where year(studate)<1997;
UPDATE student SET stuid='500102',stuname='林丽',stusex='女';