修改(Update)
UPDATE table_name SET column = expr [, column = expr …]
[WHERE …] [ORDER BY …] [LIMIT …]
-- 修改学生信息,把 唐三藏的 qq 邮箱修改为 "tangtang@fo.com"
update student set*qq_mail = "tangtang@fo" where name = "唐三藏";
-- 如果英语成绩小于 60 分,把英语成绩改为 60 分
-- 如果英语成绩大于等于 60 分,每个人的成绩都加上 5 分
update exam_result set english = english + 5 where english > 60;
update exam_result set english = 60 where english < 60;
-- 或者
select id from exam_result where english < 60;
update exam_result set english = 60 where id in (上一步找出来的 id);
update exam_result set english = english + 5 where id not in (上一步找出来的 id);
- 修改学生信息,把孙悟空的姓名改成孙猴子,同时,把学号改成 10101
update student set name = '孙猴子', sn = '10101' where name = '孙悟空';
删除(Delete)
- 删除学生表中,id 是 103 的同学
delete from student where id = 103;
-- 把学生表全部删干净
delete from student;