/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 vote390 views1 answer
Sqlite unique multiple columns
SQL
1 vote402 views1 answer
Encrypt password postgresql
SQL
3 votes336 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote448 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote369 views1 answer
Execute sql stored procedure in powershell
SQL
3 votes360 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote370 views1 answer
Vs 2019 connect to local mysql database
SQL
5 votes393 views4 answers
Mysql update column with value from another table
SQL
16 votes352 views6 answers
Mysql find and replace
SQL
4 votes317 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL