CURRENT_DATE/CURDATE() not working as default DATE value

by

It doesn’t work because it’s not supported

The DEFAULT clause specifies a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column

http://dev.mysql.com/doc/refman/5.5/en/create-table.html

More Related Contents:

  1. Left Outer Join doesn’t return all rows from my left table?
  2. How to populate a table with a range of dates?
  3. How to convert a string to date in MySQL?
  4. MySQL Query GROUP BY day / month / year
  5. How to get the number of days of difference between two dates on MySQL?
  6. Converting a date in MySQL from string field
  7. MySQL: Select All Dates In a Range Even If No Records Present
  8. Mysql: Select all data between two dates
  9. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  10. MySQL Query – Records between Today and Last 30 Days
  11. How to get difference between two dates in months using MySQL query?
  12. Select mysql query between date?
  13. How to select date from datetime column?
  14. Get the latest date from grouped MySQL data
  15. How to get an age from a D.O.B field in MySQL?
  16. Count days between two dates, excluding weekends (MySQL only)
  17. How to select the most recent set of dated records from a mysql table
  18. How to cast DATETIME as a DATE in mysql?
  19. How do I get the first day of the week of a date in mysql?
  20. MySQL date format
  21. MySQL: How to select records for this week?
  22. Select all months within given date span, including the ones with 0 values
  23. Update date + one year in mysql
  24. mysql date comparison with date_format
  25. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  26. MySQL cumulative sum grouped by date
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. MySQL: set field default value to other column
  29. MySQL: Find Missing Dates Between a Date Range
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment