mysql – 错误查询：DELETE和LEFT JOIN

DELETE FROM programSchedule 
LEFT JOIN program ON programSchedule.pid = program.id 
WHERE program.channel_id = 10

我收到此错误：

#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 ‘LEFT JOIN program ON
programSchedule.pid = program.id’ at
line 1

为什么？
最佳答案
您需要指定要从中删除的表.

DELETE programSchedule.*
FROM programSchedule LEFT JOIN program ON programSchedule.pid = program.id
WHERE program.channel_id = 10

注意：由于您要通过program.channel_id进行过滤,因此将连接更改为INNER JOIN

DELETE programSchedule.*
FROM programSchedule INNER JOIN program ON programSchedule.pid = program.id
WHERE program.channel_id = 10