mysql的Invalid default value for 'timestamp'"错误解决

sqlalchemy.exc.OperationalError: (OperationalError) (1067, "Invalid default value for 'timestamp'") "\nCREATE TABLE instance_status_history (\n\tserver VARCHAR(100) DEFAULT '' NOT NULL, \n\ttimestamp TIMESTAMP DEFAULT '0000-00-00 00:00:00', \n\tstatus VARCHAR(32) DEFAULT '' NOT NULL, \n\tPRIMARY KEY (server, timestamp)\n)\n\n" ()
localhost:htmengine-traffic-tutorial ericliu$

解决方法：

NO_ZERO_DATE：在非严格模式下，可以插入形如“0000-00-00 00:00:00”的非法日期，MySQL数据库仅抛出一个警告。而启用该选项后，MySQL数据库不允许插入零日期，插入零日期会抛出错误而非警告。

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SET GLOBAL sql_mode = '';
Query OK, 0 rows affected, 1 warning (0.00 sec)


mysql> commit;
Query OK, 0 rows affected (0.00 sec)


mysql> exit;

经过测试可以插入0日期。

mysql> INSERT INTO a SELECT 0;
Query OK, 1 row affected (0.02 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.00 sec)