How to alter a column and change the default value?

by 
ALTER TABLE foobar_data MODIFY COLUMN col VARCHAR(255) NOT NULL DEFAULT '{}';

A second possibility which does the same (thanks to juergen_d):

ALTER TABLE foobar_data CHANGE COLUMN col col VARCHAR(255) NOT NULL DEFAULT '{}';

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. In SQL Server how to get the count of child if both parent and child are available [closed]
  3. Delete the entire content of all table in a Database [closed]
  4. Rank function in MySQL
  5. MySQL select 10 random rows from 600K rows fast
  6. Get a list of dates between two dates
  7. Calculate a running total in MySQL
  8. Find nearest latitude/longitude with an SQL query
  9. Simulate lag function in MySQL
  10. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  11. Get record counts for all tables in MySQL database
  12. How do I check if a column is empty or null in MySQL?
  13. Use MySQL spatial extensions to select points inside circle
  14. INSERT … ON DUPLICATE KEY (do nothing)
  15. What is this operator in MySQL?
  16. MySQL create stored procedure syntax with delimiter
  17. Merge two tables in one SQL query and make the date values unique
  18. 60 million entries, select entries from a certain month. How to optimize database?
  19. Is it possible to GROUP BY multiple columns using MySQL?
  20. MySQL monthly Sale of last 12 months including months with no Sale
  21. How to find non-existing data from another Table by JOIN?
  22. How create json format with group-concat mysql?
  23. MySQL INSERT INTO … VALUES and SELECT
  24. MySQL LIKE query with underscore
  25. Compare only day and month with date field in mysql
  26. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  27. What is the difference between SQL and MySQL? [closed]
  28. how to use a like with a join in sql?
  29. How do you force mysql LIKE to be case sensitive? [duplicate]
  30. In what order are MySQL JOINs evaluated?

Leave a Comment