/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 vote219 views1 answer
Oracle cpu metric
SQL
1 vote316 views1 answer
Primary key reset in SQL database
SQL
0 vote216 views1 answer
Sql where time stamp is in between
SQL
0 vote180 views1 answer
Postrgres trunc
SQL
34 votes225 views5 answers
Oracle alter table add column
SQL
15 votes194 views5 answers
If null mysql
SQL
0 vote202 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote199 views1 answer
Print boolean in plsql
SQL
57 votes2.2K views5 answers
How to create a new user in postgresql
SQL
11 votes224 views5 answers
Laravel db facade
SQL