/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

-2 votes145 views3 answers
Oracle tablespace usage
SQL
0 vote143 views2 answers
Insert into
SQL
0 vote164 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
2 votes141 views2 answers
Spring import sql
SQL
0 vote161 views2 answers
Dumping sql table
SQL
0 vote155 views1 answer
Mod in sql
SQL
0 vote150 views1 answer
Alter precision
SQL
6 votes159 views1 answer
How to count number of rows in sql
SQL
1 vote152 views1 answer
Sql server list locks
SQL
1 vote153 views1 answer
Postgresql transaction discard all
SQL