关于MYSQL Datetime default value

yzgname

一个关于MYSQL datetime default value的解决办法的讨论:

http://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column

 

CREATE TABLE `MyTable` ( 
`MyTable_ID`  int UNSIGNED NOT NULL AUTO_INCREMENT , 
`MyData`  varchar(10) NOT NULL , 
`CreationDate`  datetime NULL , 
`UpdateDate`  datetime NULL , 
PRIMARY KEY (`MyTable_ID`) 
) 
; 
 
CREATE TRIGGER `MyTable_INSERT` BEFORE INSERT ON `MyTable` 
FOR EACH ROW BEGIN 
        -- Set the creation date 
    SET new.CreationDate = now(); 
 
        -- Set the udpate date 
    Set new.UpdateDate = now(); 
END; 
 
CREATE TRIGGER `MyTable_UPDATE` BEFORE UPDATE ON `MyTable` 
FOR EACH ROW BEGIN 
        -- Set the udpate date 
    Set new.UpdateDate = now(); 
END;