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

0 vote241 views1 answer
How to query without duplicate rows in sql
SQL
0 vote283 views1 answer
Python dictionary to sql update
SQL
1 vote223 views5 answers
Sql 2nd highest salary
SQL
0 vote227 views1 answer
Sql grant select only
SQL
0 vote261 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
3 votes231 views1 answer
V$session not found in oracle
SQL
1 vote258 views3 answers
Mysql on delete set null
SQL
6 votes243 views2 answers
Non relational database
SQL
0 vote247 views1 answer
Oracle running queries
SQL
3 votes242 views3 answers
Sql last week
SQL