title: MySQL set current date in a DATETIME field on insert
body: <p>I have a 'created_date' DATETIME field which I would like to be populated with the current date upon insert. What syntax should I use for the trigger for this? This is what I have so far but it is incorrect.</p>
  
  <pre><code>CREATE TRIGGER set_created_date
  BEFORE INSERT ON product
  FOR EACH ROW BEGIN
  SET NEW.created_date = now();
  </code></pre>