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

1 vote368 views1 answer
Postgres check blocking
SQL
0 vote435 views1 answer
Intellij mysql set timezone
SQL
6 votes324 views1 answer
Phpmyadmin reset root password
SQL
0 vote361 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote345 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote359 views1 answer
Helptext in sql
SQL
0 vote382 views1 answer
Sql server user permissions and roles
SQL
0 vote343 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
2 votes357 views1 answer
Guid to string sql
SQL
0 vote388 views1 answer
Order child below the parent in mysqli
SQL