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 vote263 views1 answer
Postgresql import a database of gzip
SQL
0 vote255 views1 answer
Drop all procedures sql server
SQL
6 votes261 views1 answer
Check Table Exists
SQL
7 votes298 views5 answers
Max 3 salary in sql
SQL
1 vote260 views3 answers
Psql fatal database does not exist
SQL
1 vote272 views3 answers
Java.sql.sqlexception: access denied for user
SQL
1 vote319 views4 answers
How to check table in postgresql from terminal
SQL
17 votes247 views6 answers
Sql current date
SQL
3 votes284 views1 answer
Mysql insert on dupèlicate
SQL
3 votes264 views2 answers
Oracle grants
SQL