MySQL 多表删除,只能使用别名来删除
普通的单表删除方式
DELETE FROM tab1 WHERE id = '1' ;
单表使用别名删除方式
--使用 AS 别名来删除数据
DELETE a FROM tab1 AS a WHERE a.id = '2';
--不使用 AS 别名来删除数据
DELETE a FROM tab1 a WHERE a.id = '2';
多表使用别名删除方式
--使用 AS 别名来删除数据
DELETE a FROM tab1 AS a, tab2 AS b WHERE a.id=b.id AND b.id = '2';
--不使用 AS 别名来删除数据
DELETE a FROM tab1 a, tab2 b WHERE a.id=b.id AND b.id = '2';