mysql - SQL : Error Syntax #1064

Question

我在此查询中没有发现错误:

DELETE FROM T1, T2 WHERE T2.id_user = 2 AND T1.id_cat = 2 AND T2.id_cat = 2

如果我用 'SELECT *' 替换 'DELETE' ，我会得到我想要的，但是当我使用 DELETE 时，我得到了这个错误语法 #1064。

感谢您的帮助。

Answer 1

您需要指定要删除的内容。

DELETE T1, T2
    FROM T1, T2
    WHERE T2.id_user = 2 AND T1.id_cat = 2 AND T2.id_cat = 2;

这假设您要从两个表中删除行。