/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 vote153 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote189 views2 answers
Homebrew nysql launch
SQL
-1 vote154 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
9 votes164 views4 answers
How to remove duplicate in sql
SQL
0 vote181 views1 answer
Query by column for substring sql
SQL
0 vote165 views1 answer
Oracle procedure chain step
SQL
0 vote235 views1 answer
Oracle convert int to date
SQL
0 vote180 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote174 views1 answer
Original Query
SQL
0 vote134 views1 answer
Hangfire clean script
SQL