Invalid default value for ‘create_date’ timestamp field

by

That is because of server SQL Mode – NO_ZERO_DATE.

From the reference: NO_ZERO_DATE – In strict mode, doesn’t allow '0000-00-00' as a valid date. You can still insert zero dates with the IGNORE option. When not in strict mode, the date is accepted but a warning is generated.

More Related Contents:

  1. SQL split values to multiple rows
  2. Find duplicate records in MySQL
  3. How do I escape reserved words used as column names? MySQL/Create Table
  4. How to populate a table with a range of dates?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. What is the opposite of GROUP_CONCAT in MySQL?
  9. How to Perform an UPSERT so that I can use both new and old values in update part
  10. brew install mysql on macOS
  11. MySQL: selecting rows where a column is null
  12. Convert timestamp to date in MySQL query
  13. Update a column value, replacing part of a string
  14. mysql dynamic query in stored procedure
  15. mysql: get record count between two date-time
  16. MySQL Insert Into from one Database in another
  17. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  18. MySQL multiple columns in IN clause
  19. How to select one row randomly taking into account a weight?
  20. auto_increment by group
  21. MySQL Stored Procedures not working with SELECT (basic question)
  22. ERROR 1148: The used command is not allowed with this MySQL version
  23. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  24. Too many auto increments with ON DUPLICATE KEY UPDATE
  25. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  26. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  27. Select by Month of a field
  28. MySQL Illegal mix of collations
  29. delete rows from multiple tables
  30. MySQL Multiple Joins in one query?

Leave a Comment