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

4 votes269 views1 answer
Postgresql create table with index
SQL
0 vote274 views1 answer
Update database collation in postgresql
SQL
3 votes276 views2 answers
Mysql user permission database
SQL
1 vote259 views1 answer
Display total number of tables in mysql
SQL
2 votes270 views1 answer
Sql alchemy or
SQL
0 vote251 views1 answer
Select value from previous row in postgresql
SQL
0 vote369 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote249 views1 answer
Sql from null to not null
SQL
3 votes271 views2 answers
Plsql print
SQL
0 vote292 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL