In mySQL the first two TIMESTAMP-type columns have special meanings like this (one is creation, other is modification, not sure which).
http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

Andres Freund wrote:
Hi,

On Sunday 17 August 2008, Sam's Lists wrote in "[SQLObject] Having a modified column filled in automagically...":
I'd like to be able to create a timestamp column called "mtime" in some of
my columns.  This would hold a timestamp of when the row was last modified.
Triggers on the database side?

Andres
------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
------------------------------------------------------------------------

_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to