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

5 votes320 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote330 views1 answer
Linebreak sql
SQL
3 votes314 views5 answers
Mysql get last inserted id
SQL
2 votes322 views1 answer
Get first n letter of department name in sql
SQL
0 vote325 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote323 views1 answer
Show table structure mysql console
SQL
-1 vote338 views1 answer
Select first rows postgresql
SQL
0 vote313 views1 answer
Mysql remove tabs from string
SQL
1 vote316 views1 answer
Mysql stop password policy
SQL
-2 votes334 views1 answer
No module named '_sqlite3
SQL