delete删除表记录

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)