time stamp generation and storage in MySQL

Question

i want the system to generate and store the time stamp to a column in a table when the insert query is fired in MySQL. how to make it happen?

Looks like a duplicate of: http://stackoverflow.com/questions/31096248/inserting-a-time-into-mysql-database-in-java?rq=1 — T-Heron, Feb 05 '17 at 12:50
Possible duplicate of [Why there can be only one TIMESTAMP column with CURRENT\_TIMESTAMP in DEFAULT clause?](http://stackoverflow.com/questions/4489548/why-there-can-be-only-one-timestamp-column-with-current-timestamp-in-default-cla) — Dario, Feb 05 '17 at 16:08

score 0 · Answer 1 · answered Feb 05 '17 at 13:25

Insert the current timestamp to a column 'ts' while inserting a row

CREATE TABLE t1 (   ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP   );

Insert the current timestamp to column 'ts' while inserting a new row and update the current timestamp in column 'ts' while updating data in that row

CREATE TABLE t1 (
  ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );

1 Answers1