mysql error 1067 invalid default value for timestamp





  1. Start Cmd.
  2. Type mysql -u root -p Then Press Enter.
  3. And Select Your Database (Ex "USE DATABASE <DATABASE NAME>").
  4. Tpe this SET @@session.sql_mode ="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";
  5. And Then Press Enter.

0 $type={blogger}: