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 vote272 views1 answer
How to open mysql in docker
SQL
0 vote248 views1 answer
Como leer datos de mysql esp32
SQL
0 vote241 views1 answer
Mysql timeout 30 seconds
SQL
5 votes276 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote297 views1 answer
Postgres list users and roles
SQL
2 votes267 views1 answer
Oracle table size
SQL
2 votes282 views4 answers
2nd highest salary in mysql
SQL
0 vote285 views1 answer
Drop procedure sql
SQL
0 vote273 views1 answer
How to get initials in sql
SQL
0 vote298 views1 answer
Add a new column into table
SQL