MySQL Alter table causes Error: Invalid use of NULL value

by

It looks like there are few rows with NULL value.Update all null values to a default date in that column and then try to do a alter.

Try this

--update null value rows
UPDATE enterprise
SET creation_date = CURRENT_TIMESTAMP
WHERE creation_date IS NULL;


ALTER TABLE enterprise 
MODIFY creation_date TIMESTAMP NOT NULL 
DEFAULT CURRENT_TIMESTAMP;

More Related Contents:

  1. MySQL how to fill missing dates in range?
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. Why does MYSQL higher LIMIT offset slow the query down?
  4. How to split the name string in mysql?
  5. Normalization in MYSQL
  6. Is there a REAL performance difference between INT and VARCHAR primary keys?
  7. How to set a maximum execution time for a mysql query?
  8. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  9. Getting around MySQL “Can’t reopen table” error
  10. Can’t Create Entity Data Model – using MySql and EF6
  11. In MySQL, can I copy one row to insert into the same table?
  12. How to copy a row and insert in same table with a autoincrement field in MySQL?
  13. MySQL: Cloning a MySQL database on the same MySql instance
  14. MySQL sharding approaches?
  15. access denied for load data infile in MySQL
  16. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  17. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  18. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  19. Optimization of MySQL search using “like” and wildcards
  20. Does Order of Fields of Multi-Column Index in MySQL Matter
  21. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  22. NodeJS MySQL Dump
  23. Why do I need “OR NULL” in MySQL when counting rows with a condition
  24. MySQL on delete cascade. Test Example
  25. Return Last ID (IDENTITY) On Insert row VB.NET MySQL
  26. MySQL vs. JSON – Why? [closed]
  27. Should I always prefer MySQL InnoDB over MyISAM?
  28. MySQL add 12 hours to a time field
  29. OSX ld: library not found for -lssl
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment