/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

0 vote266 views1 answer
Sql if clause within where clause
SQL
0 vote171 views1 answer
Get employees if not contains in sql
SQL
1 vote196 views2 answers
Oracle leftmost characters
SQL
6 votes210 views2 answers
Oracle compile trigger
SQL
2 votes214 views1 answer
Datefromparts mssql
SQL
0 vote160 views1 answer
Minecraft duping allowed servers
SQL
0 vote174 views1 answer
Sqlite referential integrity
SQL
0 vote175 views1 answer
Postgresql update to unique
SQL
1 vote169 views1 answer
Postgres set column equal to another
SQL
1 vote215 views1 answer
Postgresql float 2 decimal places
SQL