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

16 votes155 views2 answers
Sql vs nosql
SQL
0 vote92 views1 answer
Mssql view column data type
SQL
16 votes155 views1 answer
Mysql smallint range
SQL
1 vote127 views1 answer
Use of now() in mysql
SQL
1 vote137 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote146 views1 answer
Sql select all records from all tables where not empty
SQL
2 votes161 views3 answers
Sql server: how to concatenate column data using comma
SQL
2 votes177 views2 answers
Postgres change owner of schema
SQL
0 vote139 views1 answer
Sql server select top 2 of each group
SQL
6 votes126 views3 answers
Can you update NULL in sql
SQL