/SQL/How to add column sql

How to add column sql

Alter table add column

ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;

13

Alter table add column

ALTER TABLE table_name 
ADD column_name datatype;

9

Add column in table

ALTER TABLE table_name
  ADD column_name column_definition;

2

How to add column sql

ALTER TABLE Customers
ADD Email varchar(255);

0

Similar codes

20 votes244 views5 answers
Mysql reset auto increment to 1
SQL
0 vote282 views1 answer
Mysql disable triggers
SQL
0 vote288 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote263 views1 answer
Postgres drop type
SQL
7 votes258 views1 answer
Safe update mysql
SQL
0 vote271 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
2 votes266 views2 answers
Postgres drop column if exists
SQL
5 votes259 views1 answer
Postgres integer to serial
SQL
0 vote269 views1 answer
Php select data from mysql database without column name
SQL
0 vote284 views1 answer
Sql missing values
SQL

Share