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

0 vote172 views1 answer
Split string by comma in sql server
SQL
0 vote197 views1 answer
Oracle enable chain
SQL
0 vote178 views1 answer
How to check replication lag in mySQL
SQL
0 vote185 views2 answers
List all constraints in postgres
SQL
10 votes123 views1 answer
Oracle view dependencies
SQL
1 vote223 views1 answer
Select not matching data with join table
SQL
0 vote188 views1 answer
Mysql get nth highest
SQL
0 vote165 views1 answer
Get records in sql according to month name and count
SQL
0 vote182 views1 answer
Geopoint from json mysql function
SQL
0 vote204 views1 answer
How to find date from date table in sql
SQL