MYSQL-删除带有联接的查询 [英] MYSQL - Delete Query with Join

问题描述

我已经检查了回答的问题.但是，解决方案对我不起作用.

I have checked the answered questions. But, solutions are not working for me.

DELETE FROM TEST2
INNER JOIN TEST1 on TEST1.FIELD2 = TEST2.FIELD2
WHERE TEST1.FIELD1 = 22;

当我执行此查询时，我在phpmyadmin中收到以下错误.

When i execute this query, i am getting the following error in phpmyadmin.

#1064 - 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 'INNER JOIN TEST1 on TEST1.FIELD2 = TEST2.FIELD2' at line 2

我累了.我需要帮助.预先感谢.

I am getting tired. I need help. Thanks in advance.

推荐答案

这应该有效:

DELETE T
FROM TEST2 T
INNER JOIN TEST1 on TEST1.FIELD2 = T.FIELD2
WHERE TEST1.FIELD1 = 22;

小提琴示例

我想您也可以使用IN来做到这一点:

I think you can also do it with IN:

DELETE FROM Test2
WHERE Field2 IN (
    SELECT Field2 
    FROM Test1
    WHERE Field1 = 22)

这篇关于MYSQL-删除带有联接的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！