mysql -- 练习2

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', '花木兰',   2