Shulou(Shulou.com)06/01 Report--

Due to the upgrade of the database, there was an error executing the SQL file exported from MySQL 5.6today:

Mysql > source cms_user.sql

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.04 sec)

ERROR 1067 (42000): Invalid default value for 'CREATE_TIME'

ERROR 1146 (42S02): Table 'ixinnuo_zxpt.cms_user' doesn't exist

Because the default value of timestamp has been changed since MySQL 5.6. it cannot be "0000 00-0000: 00:00".

Solution:

View sql_mode:

Mysql > show session variables like'% sql_mode%'

+- -- +

| | Variable_name | Value |

+- -- +

| | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+- -- +

1 row in set (0.01 sec)

Modify sql_mode to remove NO_ZERO_IN_DATE,NO_ZERO_DATE:

Mysql > set sql_mode= "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Query OK, 0 rows affected, 1 warning (0.00 sec)

Re-execution, successful:

Mysql > source cms_user.sql

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.03 sec)

Query OK, 0 rows affected (0.55 sec)

Query OK, 1 row affected (0.07 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.