:-: DML-删除数据 三.delete 1.删除单表 ~~~sql DELETE FROM tablename [where CONDITION] ~~~ 实例 ~~~sql delete from test1 whre id = 1; ~~~ delete 和update操作一样，一定要带where条件，理由同上 delete 和truncate 都有删除的效果，具体还有和drop 的对比效果，见上一篇文章 2.删除多表 ~~~sql DELETE t1, t2, ..., tn FROM t1, t2, ..., tn [WHERE CONDITION] ~~~ 实例 ~~~sql delete a,b from test1 a ,test2 b where a.id = b.id and a.id = 1; ~~~ 这个场景平时使用也比较少