mysql - 将 SQL Select * 语句转换为 delete 语句

Question

我有一个 SQL 语句可以从我的数据库中提取符合条件的记录。

SELECT * FROM `t_questions` LEFT JOIN `t_syllabus` ON `t_syllabus`.`syllabus_id` =    `t_questions`.`question_syl_reference_id` WHERE `t_syllabus`.`syllabus_training_block` = 'CPL';

这可以正常工作并返回我想要的一切。

我现在需要编写一个状态来删除使用相同条件的问题。

到目前为止，我已经尝试过了，但出现错误。

DELETE FROM t_questions WHERE question_id IN(SELECT * FROM `t_questions` LEFT JOIN `t_syllabus` ON `t_syllabus`.`syllabus_id` = `t_questions`.`question_syl_reference_id` WHERE `t_syllabus`.`syllabus_training_block` = 'CPL')

我手边没有错误消息，但稍后会更新。

知道为什么这行不通吗？

谢谢。

Answer 1

试试这个

DELETE FROM t_questions 
WHERE question_id IN
              (SELECT question_id  
               FROM `t_questions`.`t_questions` LEFT JOIN `t_syllabus` ON `t_syllabus`.`syllabus_id` = `t_questions`.`question_syl_reference_id`
               WHERE `t_syllabus`.`syllabus_training_block` = 'CPL')