title: how to declare variable in trigger and use it with mysql?
body: <p>what is the error ?</p>
  
  <pre><code>DELIMITER $$
  
  CREATE TRIGGER `Task_insert_trig` AFTER INSERT ON `task` 
  FOR EACH ROW 
  begin
  declare userID int;
  
  Set userID =(select  userID from assigned_task where Atk_Task_Id = new.Tsk_Id and Atk_Project_Id = new.Tsk_Project_Id);
  insert into dashboard_event set 
  Dsh_Project_Id = new.Tsk_Project_Id,
  Dsh_Actor = userID,
  Dsh_Action = 'Assign',
  Dsh_Type = 'Task',
  Dsh_Target = new.Tsk_Id,
  Dsh_Date = now();
  $$
  end
  DELIMITER ;
  </code></pre>
  
  <blockquote>
    <p>Error Code : 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 '' at line 12</p>
    
    <p>Error Code : 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 'end
    DELIMITER' at line 1</p>
  </blockquote>