mysql error 1364 Field doesn't have a default values的解決方法

mysql> SHOW VARIABLES LIKE 'sql_mode';
+---------------+--------------------------------------------+
| Variable_name | Value                                      |
+---------------+--------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
1 row in set (0.00 sec)

打開Mysql終端並登錄
Run mysql console:
mysql -u your_username -p
選擇你的數據庫
USE your_database;
執行下面命令關閉mysql的嚴格模式
SET GLOBAL sql_mode='';