/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 votes284 views1 answer
For loop postgresql
SQL
0 vote276 views2 answers
Default constraint in ms sql
SQL
0 vote360 views1 answer
Mysql show schema
SQL
0 vote286 views1 answer
Laravel migration sql dump
SQL
0 vote281 views1 answer
Add multiple field in table sql
SQL
0 vote297 views1 answer
Oracle decode
SQL
5 votes252 views3 answers
Truncate function in sql oracle
SQL
0 vote270 views7 answers
Les jointures sql server
SQL
14 votes281 views3 answers
Oracle sql limit results
SQL
0 vote269 views4 answers
Forenkey code alchemy sql
SQL