/SQL/Alter table add multiple columns mysql

Alter table add multiple columns mysql

CREATE TABLE IF NOT EXISTS vendors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);
ALTER TABLE vendors
ADD COLUMN phone VARCHAR(15) AFTER name;

How to add more columns to a table in mysql

CREATE TABLE IF NOT EXISTS vendors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);
ALTER TABLE vendors
ADD COLUMN phone VARCHAR(15) AFTER name;

Source: mysqltutorial.org

Similar codes

1 vote221 views1 answer
Get parameter value in mysql trigger
SQL
4 votes215 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote198 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote198 views1 answer
Sql server manager close connection
SQL
0 vote217 views1 answer
Oracle execute immediate quotes
SQL
0 vote292 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote208 views1 answer
Mysql_num_fields in mysqli
SQL
6 votes201 views2 answers
Mysql get yesterday
SQL
1 vote201 views1 answer
Get last week data in mysql
SQL
1 vote277 views1 answer
Oracle grant select on schema
SQL