Mysql add column after another

-- 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 alter table add column

ALTER TABLE table
  ADD [COLUMN] column_name column_definition
  [FIRST|AFTER existing_column];

Source: mysqltutorial.org

Similar codes

0 vote299 views1 answer
Sql basic commands
SQL
0 vote258 views1 answer
Mysql find db contarint
SQL
1 vote266 views1 answer
Oracle avg
SQL
1 vote272 views1 answer
Convert varchar to int in sqlite
SQL
0 vote271 views1 answer
Mysql query with sql to get the next row
SQL
0 vote269 views1 answer
C# add a textbox in mysql select
SQL
0 vote279 views2 answers
Script all indexes in a database
SQL
5 votes275 views4 answers
Change auto increment mysql
SQL
2 votes292 views1 answer
Pdo mysql insert
SQL
0 vote257 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL