NYCPHP Meetup

[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