Delete

Delete(Delete By Query)

delete from students identify by '1234'; -- delete
# 不指定limit，默认删除条数为15条
delete from students where grade <60 batch 1000 limit 10000; -- delete_by_query