/SQL/Mysql alter column default

Mysql alter column default

Mysql alter column default

ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT 'literal';

1

Source: stackoverflow.com

Altering the column name in MySQL to have a default value

ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT 'literal';

1

Source: stackoverflow.com

Similar codes

0 vote310 views1 answer
PSQL qith variables
SQL
5 votes324 views1 answer
Mysql created at yesterdau
SQL
0 vote314 views1 answer
Mysql search multiple tables
SQL
0 vote362 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
1 vote320 views1 answer
Mysql event last execution
SQL
4 votes307 views1 answer
Oracle user tables
SQL
0 vote311 views1 answer
Mysql cdn link
SQL
0 vote297 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
11 votes297 views2 answers
Sql between date range
SQL
1 vote359 views3 answers
How to reset id column in sql server
SQL

Share