DELETE语句无法进行多表数据删除,即
delete t1, t2 from t1, t2 where ...
不可用,但可以在两个表之间建立级联关系,实现在删除表1数据的同时,删除表2的数据。
例如:delete t1, t2 from t1 left join t2 on t1.id = t2.id and t1.name = '小明',注意:此处的t1,t2不能用别名。
其它用法:
1.删除表2中id等于表1id并且表1name等于小明的数据:
delete t2 from t1,t2 where t2.id = t1.id and t1.name = '小明';
或
delete t2 using t1,t2 where t2.id = t1.id and t1.name = '小明';
(参考http://blog.csdn.net/eventys/article/details/7449297)