/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 vote142 views1 answer
Min:sec datediff mssql
SQL
0 vote154 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote147 views2 answers
Postgres copy table from one schema to another
SQL
0 vote178 views1 answer
Day of the week sqlite
SQL
0 vote154 views1 answer
Drop column from local database postgres pgadmin
SQL
1 vote170 views1 answer
Postgresql update auto_increment value
SQL
0 vote163 views1 answer
Sql server on mac m1
SQL
1 vote149 views1 answer
DATE_SUB postgres
SQL
0 vote203 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote156 views1 answer
Createdb with postgresql on ubuntu
SQL