使用Mysql触发器删除行

Question

需要在插入一个名为jos_jquarks_quizzes的表后执行触发器，我需要创建一个课程名称，它将具有与quizz名称相同的名称，但有自己的id

表

jos_jquarks_quizzes 
id     title     description     course_id 
jos_jquarks_users_training   
id     quiz_id     user_id     agree 

到目前为止，我的触发器看起来像这样，但有一个错误

-- Trigger DDL Statements
DELIMITER $$
USE `db_dhruniversity`$$
CREATE
TRIGGER `db_dhruniversity`.`ai_delete_course`
AFTER DELETE ON `jos_jquarks_quizzes`
FOR EACH ROW
BEGIN    
DELETE FROM jos_jquarks_courses
WHERE (quiz_id = new.id); 
END$$

Answer 1

where子句更改为new。Id转换为old.id

-- Trigger DDL Statements
DELIMITER $$
USE `db_dhruniversity`$$
CREATE
TRIGGER `db_dhruniversity`.`ai_delete_course`
AFTER DELETE ON `jos_jquarks_quizzes`
FOR EACH ROW
BEGIN    
DELETE FROM jos_jquarks_courses
WHERE (quiz_id = old.id); 
END$$