/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 vote188 views1 answer
How to get specific salary in sql
SQL
0 vote166 views2 answers
Influxdb delete measurement based on date
SQL
0 vote184 views1 answer
Database traccar
SQL
-1 vote192 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote186 views1 answer
Python mysql show databases
SQL
1 vote187 views1 answer
Mysql select another database
SQL
0 vote192 views1 answer
Renommer table sql
SQL
0 vote225 views1 answer
Mysql show schema
SQL
2 votes211 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote178 views2 answers
Find Overlapping sql
SQL