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

1 vote362 views1 answer
Date_part mysql
SQL
4 votes358 views3 answers
How to describe a table in sqlite3
SQL
0 vote362 views1 answer
MySQL import data from large CSV file
SQL
0 vote362 views1 answer
Sintaxis SELECT sql
SQL
0 vote354 views1 answer
Mysql drop vs delete
SQL
0 vote354 views1 answer
Mysql select field if condition
SQL
0 vote342 views1 answer
Mysql function variable
SQL
0 vote358 views1 answer
Sql server concat null
SQL
3 votes379 views1 answer
Oracle APEX elapsed time
SQL
0 vote340 views1 answer
Can sqldatareader be null
SQL