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..
>
>
> --
> Shankar.
What this means is you should be using a DATETIME field instead of a
timestamp.
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php