Web lists-archives.com

Re: get row inserted time or modified time




On Tue, 2 Jun 2015, Selvam Gce wrote:

Is there any way to get row inserted time or modified time in my mysql table???

if you define a column with any name and a type of

timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

this will automatically timestamp each record (row) with the update time


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql