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 vote345 views1 answer
Normalization in database 2nd normal form
SQL
0 vote342 views1 answer
Sql server get date of previous sunday
SQL
7 votes348 views2 answers
Oracle sql drop index
SQL
0 vote340 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote344 views1 answer
Connecting to my cloud sql server with c#
SQL
12 votes336 views1 answer
Script to add new column in table sql
SQL
0 vote347 views2 answers
Psql commande \gset
SQL
0 vote332 views1 answer
First Step in installing SQL workbench
SQL
0 vote326 views1 answer
Pl sql constraint user function
SQL
0 vote347 views1 answer
Oracle step procedure
SQL