/SQL/Mysql add column with default value

Mysql add column with default value

-- ALTER TABLE tbl_name ADD COLUMN column_name column_definition 
--		[FIRST|AFTER existing_column];
ALTER TABLE office ADD COLUMN phone VARCHAR(200) DEFAULT '000' AFTER name;
ALTER TABLE office ADD COLUMN flag INT(1) FIRST;
ALTER TABLE office ADD COLUMN last_col INT(2);	-- Last column is default position
-- ↓ Test it (Fiddle)

Source: sqlfiddle.com

Mysql add column default value

ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;

Mysql query add column with default string value

ALTER TABLE `table_name` ADD COLUMN `new_column_name` VARCHAR(255)  DEFAULT "DEFUALT_VALUE" AFTER `COLUMN_NAME`;

Similar codes

1 vote345 views1 answer
Display total number of tables in mysql
SQL
2 votes354 views1 answer
Date conversion in mysql column
SQL
0 vote348 views1 answer
View acl table oracle
SQL
1 vote418 views1 answer
Sql count value greater than
SQL
0 vote438 views1 answer
Why do we need data structure in sql
SQL
7 votes350 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote341 views1 answer
Sql get table last modified time
SQL
0 vote397 views2 answers
Coursera spark sql max count
SQL
3 votes408 views1 answer
Select count from table mysql
SQL
0 vote452 views1 answer
Calculer pourcentage mysql
SQL