title: Delete row with a Mysql Trigger
body: <p>need to do trigger after Inserting on a table called jos_jquarks_quizzes, I need to create a course name which will have the same name as the quizz name , but its own id, </p>
  
  <p>Tables</p>
  
  <pre><code>jos_jquarks_quizzes 
  
  id     title     description     course_id 
  
  jos_jquarks_users_training   
  id     quiz_id     user_id     agree 
  </code></pre>
  
  <p>So far My Trigger looks like this but has an error</p>
  
  <pre><code>-- 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$$
  </code></pre>