title: MySQL insert with the current timestamp
body: <p>I have a table in mysql as shown below </p>
  
  <pre><code>CREATE TABLE Orders (
  id                  INTEGER(10) UNSIGNED AUTO_INCREMENT,
  VendorName     VARCHAR(20),
  Item             VARCHAR(20),
  updated_at          TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  created_at          DATETIME DEFAULT NULL,
  PRIMARY KEY (id)
  );
  </code></pre>
  
  <p>I need to insert record into it , I have tried as </p>
  
  <pre><code>Insert into Orders values(123,'PoppyCounter','Chocltae','now','now')
  </code></pre>
  
  <p>I got the output as </p>
  
  <pre><code>mysql&gt; select * from Orders;
  +-----+--------------+----------+---------------------+---------------------+
  | id  | VendorName   | Item     | updated_at          | created_at          |
  +-----+--------------+----------+---------------------+---------------------+
  | 123 | PoppyCounter | Chocltae | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 |
  +-----+--------------+----------+---------------------+---------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>Could anybody please tell me how can i make a insert with the current timestamp ??</p>