Alter table change default

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

A second possibility which does the same:
ALTER TABLE foobar_data CHANGE COLUMN col col VARCHAR(255) NOT NULL DEFAULT '{}';

Source: stackoverflow.com

Similar codes

4 votes219 views1 answer
To date oracle with time
SQL
0 vote231 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote239 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote234 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote231 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
2 votes269 views1 answer
Coalesce sql
SQL
0 vote239 views1 answer
Exec procedure oracle
SQL
0 vote253 views1 answer
Postgresql find biggest table
SQL
1 vote236 views1 answer
Postgresql escape single quote
SQL
0 vote241 views1 answer
How to add unique key constraint in mysql
SQL