Invalid default value for ‘dateAdded’

by

CURRENT_TIMESTAMP is only acceptable on TIMESTAMP fields. DATETIME fields must be left either with a null default value, or no default value at all – default values must be a constant value, not the result of an expression.

relevant docs: http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html

You can work around this by setting a post-insert trigger on the table to fill in a “now” value on any new records.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. Error related to only_full_group_by when executing a query in MySql
  3. SQL split values to multiple rows
  4. Get records with max value for each group of grouped SQL results
  5. How to reset AUTO_INCREMENT in MySQL
  6. How to declare a variable in MySQL?
  7. How to populate a table with a range of dates?
  8. MySQL Query GROUP BY day / month / year
  9. MySQL Cannot Add Foreign Key Constraint
  10. Grouping into interval of 5 minutes within a time range
  11. SQL counting all rows instead of counting individual rows
  12. Convert timestamp to date in MySQL query
  13. Update a column value, replacing part of a string
  14. In MySQL, should I quote numbers or not?
  15. MySQL add days to a date
  16. mysql dynamic query in stored procedure
  17. MySQL combine two columns into one column
  18. MySQL incorrect key file for tmp table when making multiple joins
  19. Does the order of conditions in a WHERE clause affect MySQL performance?
  20. Difference between these two joining table approaches?
  21. MySQL Stored Procedures not working with SELECT (basic question)
  22. MySQL query, MAX() + GROUP BY
  23. ERROR 1148: The used command is not allowed with this MySQL version
  24. MySQL export into outfile : CSV escaping chars
  25. Simple Random Samples from a MySQL Sql database
  26. ALTER table – adding AUTOINCREMENT in MySQL
  27. MySQL Select minimum/maximum among two (or more) given values
  28. SQL query with avg and group by
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment