/SQL/Mysql query add column with default string value

Mysql query add column with default string 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 vote302 views1 answer
Concat first name and last name in mysql
SQL
1 vote268 views1 answer
Sql order by timestamp
SQL
0 vote263 views1 answer
SQL authentication error
SQL
0 vote276 views2 answers
Drop tables from local table database postgres
SQL
0 vote273 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote290 views1 answer
Having all mysql
SQL
0 vote278 views1 answer
Insert or update sql query
SQL
18 votes251 views2 answers
Sql comments
SQL
2 votes258 views1 answer
Oracle table size
SQL
0 vote264 views2 answers
Transaction php
SQL