/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 vote284 views2 answers
Mysql insert rows to another database
SQL
0 vote179 views1 answer
Sql field equals multiple values
SQL
1 vote165 views1 answer
Alter database datafile maxsize 32g
SQL
8 votes150 views2 answers
Phpmyadmin default password
SQL
4 votes189 views3 answers
Postgres drop all tables
SQL
2 votes167 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote153 views1 answer
What is logical database schema
SQL
0 vote156 views1 answer
Utiliser sql ligne de commande
SQL
0 vote157 views1 answer
Rename constraint postgresql
SQL
1 vote157 views1 answer
Load sql into mamp
SQL