/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 vote219 views1 answer
Flask sqlalchemy update row
SQL
0 vote235 views1 answer
Which lock mode is not available in sql
SQL
4 votes211 views1 answer
Wilayah indonesia database
SQL
2 votes247 views1 answer
Create mysql user on all hosts
SQL
0 vote225 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote243 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote250 views2 answers
Wordpress change url after migration mysql query
SQL
1 vote235 views2 answers
Remove space in mysql
SQL
0 vote220 views1 answer
Postgres call view
SQL
0 vote218 views1 answer
Mysql error codeigniter
SQL