Kiến thức

Fix: mysql error 1364 Field doesn’t have a default values

In phpmyadmin, perform the following: select @@GLOBAL.sql_mode Copy this result and remove STRICT_TRANS_TABLES. Then perform the following: set GLOBAL sql_mode=’ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’