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 vote206 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote213 views1 answer
Mysql range of dates overlap
SQL
0 vote193 views1 answer
Why we have to set the password for my sql server
SQL
0 vote212 views1 answer
How to run mysql on terminal mac
SQL
0 vote184 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote197 views2 answers
Check mysql timezone
SQL
1 vote184 views3 answers
Grant syntax in sql
SQL
0 vote201 views1 answer
Narural join
SQL
0 vote229 views1 answer
Sql date with year
SQL
2 votes178 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL