set_time for a field

How to know at what time a field was set

[alexis]

I want to know at what time a field was updated. I know mySql keeps track of the time at which a table was updated with

"show table status from mydatabase like 'mytable'"

but does it keep track of each individual use of SET?

I am making a bilingual website that will be edited with phpMyAdmin. It is quite convenient for the person who translates to update the text in both languages in the same table (therefore same phpMyAdmin page). I would like to be able to compare the last update time of both languages. This way I could generate a list of all the pages that need to be translated and send that list to the translator.

if mySql doens't keep track of such an information, I thought I could create 2 extra fields 'update_time_fr' and 'update_time_en'. These fields would be timestamps. 'update_time_fr' would automatically be set every time the SET command is invoked on 'text_fr' and same thing on 'update_time_en' for 'text_en'.

I know I could separate the french and the english text in 2 different tables but it would if I can avoid that.