Web lists-archives.com

Re: time stamp specific to columns




I think you'd have to do that with a trigger.


On 4/8/15 6:36 AM, Martin Mueller wrote:
I understand how a timestamp column automatically changes when there is a
change in a data row. Is it possible to limit the update to changes in
particular columns? I have a table where I care about changes in any of
four different columns, but I don¹t care about changes in other columns or
added columns.

Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d"




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql