2

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

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

Sebastien C.
  • 4,419
  • 1
  • 18
  • 32
hd.
  • 16,676
  • 43
  • 110
  • 160

2 Answers2

6

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

Pablo Santa Cruz
  • 170,119
  • 31
  • 233
  • 283
0

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.

  • Thank you,but the change happend and I want to know when It happend.I will do what you said for the feature changes. – hd. Jan 28 '12 at 11:36
  • yes need to store date time of change in trackchanges table or updated_at column in main table. –  Jan 28 '12 at 11:37