MYSQL例题和答案

CREATE TABLE employee(    id INT,    NAME VARCHAR(20),    sex VARCHAR(10),    salary FLOAT    );INSERT INTO employee VALUES(1,"zhangsan","male",2000);INSERT INTO employee VALUES(2,"lisi","male",1000);INSERT INTO employee VALUES(3,"xiaohong","female",4000);-- 将所有员工薪水修改为5000元。UPDATE employee SET salary = 5000;-- 将姓名为’zhangsan’的员工薪水修改为3000元。UPDATE employee SET salary = 3000 WHERE NAME='zhangsan';-- 将姓名为’lisi’的员工薪水修改为4000元,sex改为female。UPDATE employee SET salary = 4000,sex = 'female' WHERE NAME='lisi';-- 将xiaohong的薪水在原有基础上增加1000元。UPDATE employee SET salary = salary + 1000 WHERE NAME='xiaohong';-- select练习CREATE TABLE student(    id INT,    NAME VARCHAR(20),    chinese INT,    english INT,    math INT);INSERT INTO student(id,NAME,chinese,english,math) VALUES(1,'张小明',89,78,90);INSERT INTO student(id,NAME,chinese,english,math) VALUES(2,'李进',67,53,95);INSERT INTO student(id,NAME,chinese,english,math) VALUES(3,'王五',87,78,77);INSERT INTO student(id,NAME,chinese,english,math) VALUES(4,'李一',88,98,92);INSERT INTO student(id,NAME,chinese,english,math) VALUES(5,'李来财',82,84,67);INSERT INTO student(id,NAME,chinese,english,math) VALUES(6,'张进宝',55,85,45);INSERT INTO student(id,NAME,chinese,english,math) VALUES(7,'黄蓉',75,65,30);INSERT INTO student(id,NAME,chinese,english,math) VALUES(7,'黄蓉',75,65,30);-- 查询表中所有学生的信息。SELECT * FROM student;-- 查询表中所有学生的姓名和对应的英语成绩。SELECT NAME '名字', english '英语成绩' FROM student;-- 过滤表中重复数据。SELECT DISTINCT * FROM student;-- 统计每个学生的总分。SELECT NAME '名字', (chinese + english + math) '总成绩' FROM student;-- 在所有学生总分数上加10分特长分。SELECT NAME '名字', (chinese + english + math + 10) '总成绩' FROM student;-- 使用别名表示学生分数。-- 查询英语成绩大于90分的同学SELECT  * FROM student WHERE english > 90;-- 查询总分大于200分的所有同学SELECT  * FROM student WHERE (chine