title: adding current time in column while inserting mysql
body: <p>So I have this table</p>
  
  <pre><code>create table c_order(
      order_date         date               not null,
      order_id           number,
      customer_id        number             not null,
      product_id         number             not null,
      primary key (order_id),
      foreign key (customer_id) references Customer(customer_id),
      foreign key (product_id) references products(product_id)
  );
  </code></pre>
  
  <p>where customers order for a product.</p>
  
  <p>Now I want it be such that when a data is entered using <code>'Insert into'</code> then we need not insert the date rather it will be automatically saved to current data. Should I change <code>create table</code> structure for that or use a trigger? What is the syntax then? In trigger is it before/after insert?</p>