/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

3 votes167 views2 answers
Pl sql escape '
SQL
0 vote195 views1 answer
Less than date query sqlachemy
SQL
0 vote161 views1 answer
Count the table indatabase
SQL
1 vote191 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote188 views1 answer
Use where instead of join
SQL
0 vote195 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote193 views1 answer
Mysql replication change database name
SQL
0 vote181 views1 answer
Version and edition of SQL Server Database Engine
SQL
4 votes183 views1 answer
Oracle show errors
SQL