/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 vote270 views1 answer
Mysql config slave
SQL
0 vote282 views1 answer
Sql server remove primary key without dropping table
SQL
7 votes318 views1 answer
Show line number in sql server
SQL
1 vote313 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
18 votes270 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
10 votes257 views4 answers
Primary key sql
SQL
0 vote247 views1 answer
Month mysql
SQL
0 vote217 views1 answer
Sql count how many times a value appears
SQL
0 vote305 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote265 views1 answer
SQL server query column yes or no
SQL

Share