DELETE a FROM table1 a, table2 b WHERE a.id = b.id END DELETE后面FROM前面 要跟删除目标表的别名。没有别名,要跟表名。 转载于:https://my.oschina.net/tanwen/blog/892310