Mysql add column 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

20 votes355 views1 answer
Get all table name in sql through php
SQL
4 votes327 views1 answer
Oracle session date format
SQL
3 votes324 views1 answer
Fk in insert mysql
SQL
2 votes311 views1 answer
Oracle log files
SQL
0 vote343 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote333 views1 answer
Suse status MySQL
SQL
1 vote328 views1 answer
Postgresql escape single quote
SQL
0 vote332 views1 answer
Postgresql using reserved word as column name
SQL
9 votes342 views4 answers
How to alter table column name in mysql
SQL
0 vote312 views1 answer
Sql gap missing values
SQL