C&R看这篇:MySQL学习(二)DML基础之C&R_ᝰꫛꪮꪮꫜ*的博客-CSDN博客
这一篇,整理一下修改Update和删除Delete
目录
1.Update
-- update以行为单位进行删除,无指明哪几行,则全部行的指定列修改
update exam_result set math = 1;
-- 用where语句限制修改哪几行
update exam_result set chinese = 4, math = 4, english = 4 where name = '孙悟空';
-- update 支持 limit,但不支持 limit, offset
update exam_result set chinese = 40, math = 40, english = 40 order by id limit 3;
-- update不能用+=,只能写作=的形式,如下
update exam_result set math = math + 1;
2.Delete
【注】与Delete类似的还有 truncate(截断),该词类似于Java中的 list.clear() 操作,时间复杂度为 O(1),而Delete操作则是先for-each遍历再逐个删除
-- 删除整张表
truncate exam_result;
-- delete删除整张表
delete from exam_result;
-- delete也以行数为单位进行删除,删除指定行数
delete from exam_result where id < 2;
delete from exam_result order by id limit 3;