/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 vote301 views1 answer
Pl/ sql change currency
SQL
0 vote274 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
10 votes327 views5 answers
Create table mysql query
SQL
0 vote288 views1 answer
Double in sql server example
SQL
60 votes500 views6 answers
Add column in sql
SQL
0 vote307 views1 answer
Mssql + bit + in python orm
SQL
2 votes295 views1 answer
Get hour from date sql
SQL
-2 votes308 views1 answer
Trunc in sql
SQL
3 votes289 views1 answer
How to uninstall microsoft sql server
SQL
0 vote315 views1 answer
The package java.sql is not accessible
SQL