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

2 votes120 views2 answers
How to add not null constraint in sql
SQL
1 vote142 views1 answer
Sql set auto increment back to 0
SQL
0 vote130 views1 answer
Compression of dabatase mysqldumo
SQL
6 votes119 views1 answer
Update left join mysql
SQL
0 vote115 views1 answer
Adding primery key constraint to a column
SQL
0 vote130 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote117 views1 answer
Mysql trim characters
SQL
8 votes112 views1 answer
Today minus 15 days postgresql
SQL
0 vote132 views1 answer
T sql dynamic top n query
SQL
3 votes125 views2 answers
Enter mysql command line
SQL