Insert date into mysql table cell when any cell from same row has been edited
Posted on 2011-03-25
I've got column in mysql table called 'date' and I want to have it automatically updated every time I edit any cell in specific row or in other words: every time when some cell has changed. Is there possible to do the following thing in mysql itself?
1 12/01/2010 name surname address
1 26/03/2011 sam surname address
In this case I changed 'name' to 'sam' and date has been changed automatically. I can do this in php, but if I can do this in mysql itself, it would save a lot of time, because I have quite many scripts for this table. I use php for editing mysql database.
Thanks for any help.