delete 删除表记录
格式1:删除所有的表记录
delete from 表名;
格式2:仅删除符合条件的记录
delete from 表名
where 条件;
mysql> delete from user where shell is null;
mysql> select * from user where shell is null;
Empty set (0.00 sec)
delete 删除表记录
格式1:删除所有的表记录
delete from 表名;
格式2:仅删除符合条件的记录
delete from 表名
where 条件;
mysql> delete from user where shell is null;
mysql> select * from user where shell is null;
Empty set (0.00 sec)
转载于:https://www.cnblogs.com/summer2/p/10788094.html