Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
mysql auto store datetime for each row using -'sql,mysql,datetime,audit'
mysql auto store datetime for each row ¬†using -'sql,mysql,datetime,audit'
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?
Sep 7, 2015
to add a comment.
Related Hot Questions
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please