if you define a column with any name and a type of
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Thanks Lucio,
This is much better advice than the NOW() built-in function I would
have suggested.
Kind Regards,
-Bob
--
MySQL General Mailing List
For list archives:
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
Is there any way to get row inserted time or modified time in my mysql table?
Thanks Regards,
Selvam | Linkedin
Hi
you should do that in your App with Triggers and an audit table.
You will see timestamps also in binary log (in case you enabled that)
On Tue, Jun 2, 2015 at 11:28 AM, Selvam Gce selvam...@yahoo.com wrote:
Is there any way to get row inserted time or modified time in my mysql
table