[nycphp-talk] mySQL create table problem
D C Krook
dkrook at hotmail.com
Thu Aug 14 10:32:19 EDT 2003
I know Phil's problem has been solved, but just an FYI about 'timestamp'
columns; they get set to system time not only when you INSERT the row, but
anytime you UPDATE it.
It seems self-evident when you think about the purpose of the column type,
but it's easy to forget to set the column's value to itself when you want to
preserve the existing timestamp while doing unrelated administrative work on
the table.
For that reason, I would recommend sticking with the 'datetime' column and
manually updating it to NOW() when necessary.
>On the datetime type - can you use a timestamp which would automatically be
>set to the system date/time
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
More information about the talk
mailing list