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,649
  • 1
  • 21
  • 32
hd.
  • 17,596
  • 46
  • 115
  • 165

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
  • 176,835
  • 32
  • 241
  • 292
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