error code 1292 incorrect date value mysql

by

With mysql 5.7, date value like 0000-00-00 00:00:00 is not allowed.

If you want to allow it, you have to update your my.cnf like:

sudo nano /etc/mysql/my.cnf

find

[mysqld]

Add after:

sql_mode="NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Restart mysql service:

sudo service mysql restart

Done!

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. String concatenation in MySQL
  5. MySQL: How to allow remote connection to mysql
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. Cannot connect to Database server (mysql workbench)
  10. How to connect mysql workbench to running mysql inside docker?
  11. MySQL Workbench: How to keep the connection alive
  12. How do I retrieve my MySQL username and password?
  13. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  14. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  15. MySQL error 1022 when creating table
  16. Is there a naming convention for MySQL?
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. MySQL Errno 150
  19. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  20. Order by FIELD in MYSQL
  21. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  22. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  23. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  24. mySQL query to search all tables within a database for a string?
  25. Create a new database with MySQL Workbench
  26. Errno 121, duplicate key on write or update?
  27. Format number to 2 decimal places
  28. INSERT … ON DUPLICATE KEY (do nothing)
  29. Are SELECT type queries the only type that can be nested?
  30. How to Get True Size of MySQL Database?

Leave a Comment