Mysql row insert time

Question

How to get insert time of rows in mysql without using time-stamp in columns? Or is it possible of getting each row creation/insertion time in mysql ? If yes , Please let me know.

Answer 1

MySQL has function NOW() or synonymous CURRENT_TIMESTAMP() which contains current datetime.

Ex.

INSERT INTO `table` (`col1`, `col2`, `created`) VALUES ('val1', 'val2', NOW())

Without this column there is no chance to get a time when the record was created.