/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

61 votes337 views6 answers
Mysql add column
SQL
17 votes143 views6 answers
Change column name in sql
SQL
0 vote135 views1 answer
Create table sql generator
SQL
2 votes178 views6 answers
In operator in sql
SQL
0 vote155 views1 answer
Google sheets data validation custom formula filter
SQL
1 vote190 views1 answer
Postgres set sequence value to max id
SQL
0 vote139 views1 answer
Apex for oracle 11g
SQL
0 vote128 views1 answer
Show specific events on mysql
SQL
0 vote139 views1 answer
Mysql query with sql to get the next row
SQL
3 votes129 views1 answer
Select without null values sql
SQL