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

5 votes196 views1 answer
Oracle list packages
SQL
0 vote242 views1 answer
Mysql remove last character
SQL
1 vote231 views3 answers
Nth highest salary
SQL
0 vote236 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote211 views1 answer
Get total and distict row diff in sql
SQL
0 vote186 views2 answers
Plan d'exécution requete oracle autotracer
SQL
16 votes222 views1 answer
Mysql smallint range
SQL
0 vote191 views1 answer
Mysql, how to query the table comments?
SQL
6 votes243 views2 answers
Install psql mac
SQL
3 votes177 views1 answer
APEX elapsed time
SQL