一、单表更新 UPDATE
更新前数据表:
更新语句:
update users set age = age+5;
更新后数据表:
一次更新多列:
UPDATE users SET age = age - 5,sex = 0;
更新后:
有条件的更新:
update users set age = id + 10 where id%2 ==0;
更新后:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
二、删除操作
delete from users where id = 2;
删除后:
若此时再新增一记录,其编号为5.