/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

1 vote293 views1 answer
Oracle difference between two dates in years
SQL
0 vote264 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote289 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
1 vote275 views1 answer
Mysql best tutorial for beginners
SQL
0 vote293 views4 answers
What is unique key in sql
SQL
1 vote307 views1 answer
Floor function in sql oracle
SQL
8 votes354 views3 answers
Find table for column name in sql
SQL
1 vote276 views1 answer
Sql Split string function
SQL
2 votes270 views2 answers
Mysql date range
SQL
2 votes294 views1 answer
Creating a view SQL
SQL