mysql 自动添加datetime_MySQL自动存储每行的datetime

In MySQL, I'm sick of adding the columns dt_created and dt_modified (which are date time stamps for creation and last modified respectively) to all the tables I have in my database.

Every time I INSERT or UPDATE the database, I will have to use the NOW() keyword. This is going all over my persistence.

Is there any efficient alternative where MySQL can automatically store at least the datatime of the row that is inserted and let me retrieve it?

解决方案

You can use DEFAULT constraints to set the timestamp:

ALTER TABLE

MODIFY dt_created datetime DEFAULT CURRENT_TIMESTAMP

ALTER TABLE

MODIFY dt_modified datetime DEFAULT ON UPDATE CURRENT_TIMESTAMP

Then you wouldn't have to specify NOW() in your INSERT/UPDATE statements.