/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

4 votes312 views1 answer
Sql delete multiple conditions
SQL
1 vote296 views1 answer
SQL Integer devision
SQL
0 vote291 views1 answer
Exclude last comma separated string mysql
SQL
3 votes283 views3 answers
Concatenation in sql
SQL
0 vote293 views1 answer
Mysql select inside sum
SQL
9 votes291 views4 answers
SQL Date Format
SQL
0 vote236 views1 answer
Check if has alpha characters sql
SQL
1 vote317 views1 answer
Set id count mysql
SQL
0 vote284 views1 answer
Mysql changer nom table
SQL
0 vote279 views1 answer
Power query case when
SQL