Shankar Unni wrote:
> Sinisa writes:
>> - timestamp is saved in datetime format
>> - first timestamp column is silently updated on each UPDATE
> What this means, of course, is that when you want to deal with your own
> TIMESTAMP data, you need to maintain some sort of sacrificial column (e.g.
> "LAST_UPDATED TIMESTAMP") that can be subjected to this automatic update
> (and must be the first TIMESTAMP column in your table!), so that MySQL
> leaves your other "real" TIMESTAMP columns alone.
> Though really, this behavior should be an *option* (preferably a *per-table*
> option) in MySQL, not an automatic feature (i.e. assuming that any TIMESTAMP
> column must be a "last-updated" type column data). TIMESTAMP is an ANSI type
> with its own defined semantics, and it's perfectly valid to expect that the
> user may want to maintain their own timestamp data without MySQL making any
> assumptions about it..
What this means is you should be using a DATETIME field instead of a
Gerald L. Clark