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 vote129 views1 answer
T-SQL Retry (deadlock)
SQL
3 votes129 views1 answer
Only join in sql
SQL
1 vote122 views1 answer
Sql headers delphi
SQL
0 vote150 views1 answer
Savepoint mysql script
SQL
2 votes114 views2 answers
How to get capital letter first in sql
SQL
0 vote150 views1 answer
Add a new column into table
SQL
6 votes120 views3 answers
Update with inner join postgres
SQL
0 vote208 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote114 views1 answer
Inser into example
SQL
1 vote143 views1 answer
Delete specific row in sql
SQL