Mysql alter table add column first

-- 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

Add column in mysq

ALTER TABLE Table_name
ADD Email varchar(255);

Add new column to the table mysql

ALTER TABLE `TABLE_NAME` 
	ADD `COLUMN_NAME` VARCHAR(50) NULL
    AFTER `COLUMN_NAME_AFTER`;

Mysql alter table add column

ALTER TABLE table
  ADD [COLUMN] column_name column_definition
  [FIRST|AFTER existing_column];

Source: mysqltutorial.org

Similar codes

3 votes169 views2 answers
Monthname sql
SQL
4 votes246 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote165 views1 answer
How to remove identity from a column in sql server
SQL
0 vote170 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
2 votes167 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote241 views2 answers
Return the number of records in a single table mysql
SQL
0 vote170 views1 answer
T sql return on letters only
SQL
2 votes115 views1 answer
Select sid oracle
SQL
8 votes164 views3 answers
Postgres connection string
SQL
1 vote169 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL