TIMESTAMP + NOT NULL = DEFAULT Value CURRENT_TIMESTAMP ??? (no replies)
(MySQL.com) Hello!
I have a table "test" and a TIMESTAMP column "datetimecreated" in it. The values in this column may not be NULL:
CREATE TABLE IF NOT EXISTS 'test' (
'id' INT NOT NULL AUTO_INCREMENT ,
'label' VARCHAR(100) NULL ,
'description'
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-01 21:50:43
