add column in mysq
ALTER TABLE Table_name ADD Email varchar(255);
create column mysql terminal
alter table icecream add column flavor varchar (20) ;
Source: www.thoughtco.com
mysql add column
ALTER TABLE table_name ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];
Source: www.mysqltutorial.org
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 first position mysql
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)