/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

4 votes308 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote277 views1 answer
Print boolean in plsql
SQL
22 votes257 views3 answers
Sql cheat sheet
SQL
0 vote258 views1 answer
Gcloud check sql
SQL
2 votes268 views1 answer
Set username and password for postgresql database
SQL
-1 vote263 views1 answer
Count occurrences sql
SQL
2 votes271 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote267 views1 answer
Update database collation in postgresql
SQL
0 vote257 views1 answer
Group_concat only returns one row
SQL
0 vote277 views1 answer
Sql drop procedure if exists
SQL