/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

1 vote203 views1 answer
Mysql show data from table
SQL
2 votes222 views1 answer
Sql as
SQL
3 votes181 views1 answer
Postgresql where current year
SQL
0 vote224 views1 answer
How to make full text search dynamic in mysql
SQL
32 votes229 views6 answers
How to change column name in sql
SQL
37 votes225 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
9 votes225 views1 answer
No sql
SQL
0 vote219 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote217 views1 answer
What is intersect
SQL
0 vote178 views1 answer
How to check oracle index table
SQL