title: use same trigger for different tables
body: <p>I'm trying to have same trigger name for different tables while inserting new data in MySQL.
  Consider X and Y tables.
  Both tables have created_date column.</p>
  
  <p>Question is, can I have same single trigger function to effect on both tables while inserting into those tables separately.</p>
  
  <blockquote>
    <p>TRIGGER <code>insert_current_date</code> BEFORE INSERT ON <code>X</code> FOR EACH ROW SET
    NEW.created_date = NOW( )</p>
  </blockquote>
  
  <p>This only allow for X table.</p>
  
  <p>For Y table also I need same trigger function.</p>
  
  <p>Is it possible to do with single trigger function?</p>