内部连接和删除在 mysql 中不起作用 [英] Inner join and delete not working in mysql

问题描述

我有两个表 table1 和 table2.我想根据 table2 中的条件从 table1 中删除.

I have two tables table1 and table2. I want to delete from table1 based on a condition in table2.

我有以下 mysql 查询:

I have the following mysql query:

DELETE FROM table1 
INNER JOIN table2 ON table2.col1 = table1.col1
WHERE table2.col2 = '1'

这会返回一个语法错误.上面的语法有问题吗?

This return a syntax error. Is there something wrong with the above syntax?

推荐答案

您需要指定要从中删除的表:

You need to specify the table you are deleting from:

DELETE table1
    FROM table1 INNER JOIN
         table2
         USING (col1) 
    WHERE table2.col2 = '1';

这篇关于内部连接和删除在 mysql 中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！