/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 vote358 views1 answer
Oracle insert multiple rows into same table
SQL
6 votes341 views2 answers
Mysql interval 1 day
SQL
0 vote376 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
10 votes289 views1 answer
Oracle view dependencies
SQL
4 votes312 views2 answers
DB::transaction
SQL
0 vote379 views1 answer
Oracle chain step succeeded
SQL
0 vote339 views2 answers
How covert into int in maria db
SQL
0 vote324 views1 answer
How to create a table in sql stack overflow
SQL
1 vote320 views1 answer
Tsql random number
SQL
3 votes325 views3 answers
Into in sql
SQL