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

6 votes134 views1 answer
Update left join mysql
SQL
0 vote146 views1 answer
Alter column to not null with default value sql server
SQL
0 vote130 views1 answer
Drop all tables db2
SQL
5 votes131 views2 answers
Get number of columns sql
SQL
0 vote186 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote130 views2 answers
How to tun mysql on ubunto
SQL
16 votes133 views4 answers
Ascending order mysql
SQL
0 vote137 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote127 views1 answer
Learn sqlite dart
SQL
0 vote137 views1 answer
Create table in dbms cmds
SQL