title: Send email from MySQL trigger when a table updated
body: <p>Consider a table as <code>table2</code>, i like to add a <code>trigger</code> on this table <code>update</code> as</p>
  
  <pre><code>select Num into num from table1 where ID=new.id;
  BEGIN
  DECLARE done int default false;
  DECLARE cur1 CURSOR FOR select EmailId from users where Num=num;
  DECLARE continue handler for not found set done = true;
  OPEN cur1;
  my_loop: loop
      fetch cur1 into email_id;
      if done then
          leave my_loop;
      end if;
      //send mail to all email id.
  end loop my_loop;
  close cur1;
  END;
  </code></pre>
  
  <p>Is there any simple method to write in the place commented? To send a email to all the email id retrieved from table <code>users</code>.</p>
  
  <p>I am using MySQL in XAMPP(phpmyadmin).</p>