Re: best way to handle two timestamp times

2006-03-27 Thread Gabriel PREDA
You can make the first timestamp without autoupdating and a default value with no importance... and the second with DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP When you insert a new row.. .you'll use: Asuming the table has columns: col1, ., colN, col_timestamp1, col_timestamp2 INSER

best way to handle two timestamp times

2006-03-27 Thread jonathan
I've looked around the web and found very diffreing ideas about how this should be handled. Basically, I want to have a content row that has two times, the time that an insert was done and the time that it was last updated if any. I keep getting an error when I try to create a table with t