mysql - SQL 根据 idx = 1 里面的条件找到 idx = 2, 然后删除的语句怎么写？

Answer 1

delete deletes the actual table, while the result of the join query (join) is a "temporary table". If you want to do it all at once, you need to use a subquery: delete from xxx where xx in (select...)