/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 vote101 views1 answer
Change schema of all tables postgres
SQL
2 votes97 views1 answer
Match in sql server
SQL
15 votes99 views4 answers
Create table if not exists sql
SQL
0 vote180 views1 answer
Sql database size
SQL
0 vote55 views1 answer
Ms sql print more than 1 variable
SQL
5 votes112 views1 answer
Oracle asynchronous update
SQL
-2 votes109 views1 answer
Modify column name in tsql
SQL
13 votes94 views6 answers
Mysql update from select
SQL
2 votes92 views2 answers
Get all columns from table sql
SQL
0 vote101 views1 answer
Mysql query to check record exists in database table or not
SQL