Posted by Joshie Surber on 04/24/06 03:14

> Is there a way to set up a date field, Last_Update, that would
> automatically update to today's date any time a record was added or
> changed using phpmyadmin?

Simply use the MySQL field type of "TIMESTAMP" and set it to null on
any updates to the table... TIMESTAMP fields are automagically set to
the current time when the value passed to it is null.

PS this post should actually be on comp.databases.mysql. I don't care
much but some people in usenet are real pricks about stuff like this.

[Back to original message]