/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 vote120 views1 answer
Mysql locate
SQL
3 votes122 views1 answer
Oracle list dates without weekends
SQL
0 vote119 views1 answer
Inner joint
SQL
2 votes137 views1 answer
Sql missing records from another table
SQL
0 vote130 views1 answer
Oracle calculate statistics on partition
SQL
5 votes81 views1 answer
Mongodb vs
SQL
1 vote136 views1 answer
Describe table in sql
SQL
0 vote134 views1 answer
Mysql backup query
SQL
44 votes239 views4 answers
Mysql alter table add column first
SQL
0 vote125 views1 answer
Access mysql database docker container shell
SQL