删除行与一个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$$