19:创建表stu(id ,name,age,class,grade,chinese,math,english,birthday),查询出stu表中张姓同学的各科成绩信息;
drop table if exists stu;
create table stu (
id int(3) UNSIGNED zerofill primary key ,
name varchar(10),
age tinyint ,
class varchar(10),
grade varchar(10),
chinese decimal(3.1),
math decimal(3.1),
english decimal(3.1),
brithday date
);
insert into stu values
( '1', '王昭君', 26, '1班', '1年级',85,95,96, 20080212),
( '2', '李白', 19, '2班', '1年级',87,97,65, 20100514),
( '3', '刘备', 29, '1班', '1年级',85,56,94, 20100321),
( '4', '关羽', 27, '4班', '2年级',97,86,94, 20120517),
( '5', '张三', 25, '1班', '1年级',86,95,90, 20141204),
( '6', '孙尚香', 20, '3班', '2年级',64,62,55, 20150419),
( '7', '大乔', 19, '1班', '1年级',86,45,56, 20110518),
( '8', '小乔', 18, '3班', '2年级',85,75,90, 20130412),
( '9', '李白', 20, '4班', '2年级',67,80,58, 20110524),
( '10', '公孙离', 24, '4班', '1年级',84,65,61, 20090512),
( '11', '夏洛特', 20, '1班', '2年级',88,68,67, 20110815),
( '12', '风三扬', 22, '2班', '1年级',86,90,84, 20110516),
( '13', '妲己', 20, '3班', '2年级',96,80,94, 20090529),
( '14', '黄忠', 24, '2班', '1年级',70,87,61, 20110819),
( '15', '花木兰', 23, '1班'