Add column in mysq

Mysql add column

-- 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 column in mysq

ALTER TABLE Table_name ADD name_column INT(255);

Similar codes

17 votes323 views4 answers
Show all tables in oracle
SQL
1 vote185 views1 answer
Sql server 2012 query history
SQL
0 vote221 views1 answer
How to insert same table data using mysql query
SQL
0 vote235 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote189 views1 answer
Oracle last character of string
SQL
18 votes158 views2 answers
How to get all the tables displayed in oracle
SQL
12 votes188 views4 answers
Mysql ifnull
SQL
0 vote199 views1 answer
Postgres sequence name
SQL
1 vote190 views1 answer
Join first name and last name sql
SQL
4 votes203 views2 answers
Sql offset
SQL