CODEWITHSUNDEEP
mysql
hd.
hd.

Reputation: 18296

How to get the date of record updating in MySQL

I have a table that one of this record has been changed.

Is there any MySQL function to get the date of this updating?

Upvotes: 2

Views: 142

Answers (2)

user319198
user319198

Reputation:

Well it depends on how you are using the data value.

but mostly it is a good practice to have both created_at and updated_at as attributes for your table.

OR if you want to keep each update date info for a record then store them in different table. before each update in main table insert existing row in tracking table from main table.

Upvotes: 0

Pablo Santa Cruz
Pablo Santa Cruz

Reputation: 181270

No. There is no way to get that modification date unless you explicitly stored it somewhere else (through a trigger or application side technique).

Upvotes: 6

Related Questions