[nycphp-talk] mySQL create table problem

D C Krook dkrook at
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*

More information about the talk mailing list