mysql error 1364 Field doesn’t have a default values

by

This is caused by the STRICT_TRANS_TABLES SQL mode defined in the

%PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini

file. Removing that setting and restarting MySQL should fix the problem.

See https://www.farbeyondcode.com/Solution-for-MariaDB-Field–xxx–doesn-t-have-a-default-value-5-2720.html

If editing that file doesn’t fix the issue, see http://dev.mysql.com/doc/refman/5.6/en/option-files.html for other possible locations of config files.

More Related Contents:

  1. How to create a MySQL hierarchical recursive query?
  2. MySQL Error 1215: Cannot add foreign key constraint
  3. MySQL Server has gone away when importing large sql file
  4. How to select a column name with a space in MySQL [duplicate]
  5. Are you allowed to use numbers as table names in MySQL?
  6. How do you select every n-th row from mysql
  7. Howto: Clean a mysql InnoDB storage engine?
  8. How do I use on delete cascade in mysql?
  9. Add Foreign Key to existing table
  10. Auto Generate Database Diagram MySQL [closed]
  11. How to access remote server with local phpMyAdmin client?
  12. What’s the difference between using INDEX vs KEY in MySQL?
  13. MySQL/Writing file error (Errcode 28)
  14. mysql select top n max values
  15. MySQL : Multiple row as comma separated single row
  16. MySQL Trigger: Delete From Table AFTER DELETE
  17. Return a default value if single row is not found
  18. How to find out the MySQL root password
  19. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  20. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  21. How to restrict a column value in SQLite / MySQL
  22. How to get the max of two values in MySQL?
  23. How to connect locally hosted MySQL database with the docker container
  24. how to partition a table by datetime column?
  25. MySQL Alter table causes Error: Invalid use of NULL value
  26. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  27. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  28. Migrating data into Firebase from MySQL
  29. Inventory management with stock options
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment