mysql - 删除并出现连接错误

Question

执行此查询后:

 DELETE from  swimming_class as tb1 JOIN  (SELECT class_id FROM `swimming_class`
 left join swimming_school on swimming_school.school_id = swimming_class.school_id
 where swimming_school.school_name is NULL)  as temp ON temp.class_id = tb1.class_id

我收到此错误:

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 'as tb1 JOIN (SELECT class_id FROM swimming_class left join swimming_school on' at line 1

Answer 1

我认为您真正追求的是以下内容( SQL Fiddle ):

DELETE sc
FROM swimming_class sc
INNER JOIN swimming_school ss ON ss.school_id = sc.school_id
WHERE ss.school_name is NULL