/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

18 votes164 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote213 views1 answer
Age postgres
SQL
0 vote192 views1 answer
Mysql money value
SQL
0 vote246 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
4 votes219 views2 answers
Xampp mysql database server is not starting mac m1
SQL
1 vote214 views1 answer
Snowflake rename column name
SQL
0 vote224 views1 answer
Sql waitfor
SQL
2 votes246 views1 answer
Username sql
SQL
0 vote192 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote228 views1 answer
Reindex mssql table
SQL