/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 vote311 views2 answers
Getting customers with no orders sql
SQL
0 vote325 views1 answer
Duplix print in Smartforms
SQL
0 vote277 views1 answer
FindAllBy
SQL
3 votes309 views1 answer
Oracle user quota on tablespace
SQL
2 votes369 views1 answer
Sql find not in list
SQL
1 vote310 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote332 views2 answers
Greater than sql server
SQL
17 votes311 views3 answers
How to change a collumn name in sql
SQL
0 vote331 views1 answer
How to add session data into mysql database from button
SQL
0 vote308 views1 answer
Oracle create package specification
SQL