TimeStamp 设置 default值

TimeStamp设置默认值

 

如果想将一个TimeStamp字段的default值设置成 '0000-00-00 00:00:00'

 

那么需要声明 traditional SQL Mode 否则“zero”会被认为不合法的类型值

 

官网说明

 

http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

 

以下是原文

Note

The examples that use DEFAULT 0 will not work if the NO_ZERO_DATE SQL mode is enabled because that mode causes “zero” date values (specified as 0, '0000-00-00, or '0000-00-00 00:00:00') to be rejected. Be aware that the TRADITIONAL SQL mode includes NO_ZERO_DATE.

 

 

Demo

 

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

SET SQL_MODE=@OLD_SQL_MODE;