MYSQL语法不正确

杰西·麦肯齐(Jess McKenzie)

我在下面的语句中出现以下错误 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c JOIN campaignsFroms f ON f.id = c.id JOIN campaignsRaw r ON r.' at line 2

我缺少什么语法?

代码:

DELETE 
    FROM campaigns c
    JOIN campaignsFroms f      ON f.id = c.id
    JOIN campaignsRaw r        ON r.id = c.id
    JOIN campaignsSubjects s   ON s.id = c.id
    JOIN campaignIPTracking ip ON ip.id = c.id
    JOIN campaignTracking ct   ON ct.id = c.id
    WHERE c.id = '1582'
考希克·马埃塔(Kaushik Maheta)
 DELETE c
FROM campaigns c
JOIN campaignsFroms f      ON f.id = c.id
JOIN campaignsRaw r        ON r.id = c.id
JOIN campaignsSubjects s   ON s.id = c.id
JOIN campaignIPTracking ip ON ip.id = c.id
JOIN campaignTracking ct   ON ct.id = c.id
WHERE c.id = '1582'                                 

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章