MySQL – Cannot insert NULL value in column, but I have a default value specified?

by

Use the DEFAULT keyword instead:

INSERT INTO users (TimeZoneId) VALUES (DEFAULT);

More Related Contents:

  1. SELECT POPULAR POST
  2. How to filter SQL results in a has-many-through relation
  3. How to convert an entire MySQL database characterset and collation to UTF-8?
  4. How to delete from multiple tables in MySQL?
  5. How to get list of dates between two dates in mysql select query [duplicate]
  6. Using variable in a LIMIT clause in MySQL
  7. UTF-8: General? Bin? Unicode?
  8. Run MySQLDump without Locking Tables
  9. For loop example in MySQL
  10. How to convert number of week into date?
  11. count(*) and count(column_name), what’s the diff?
  12. When to use SELECT … FOR UPDATE?
  13. MySQL Select Date Equal to Today (having datetime as the data type)
  14. BULK INSERT in MYSQL
  15. Count table rows
  16. MYSQL sum() for distinct rows
  17. mysql root password forgotten
  18. How to deploy local MySQL database to Heroku
  19. Should I use MySQL blob field type?
  20. How to lock a single row
  21. MySQL Cannot drop index needed in a foreign key constraint
  22. MySQL Insert & Joins
  23. Does MySQL overwrite a column of same value on update?
  24. How to join two tables using a comma-separated-list in the join field
  25. mysql like performance boost
  26. MySQL selecting yesterday’s date
  27. Does MySQL included with MAMP not include a config file?
  28. How to regex in a MySQL query
  29. How do I write an SP in phpMyAdmin (MySQL)?
  30. Syntax error on MERGE statement

Leave a Comment