/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

5 votes376 views3 answers
Mysql remove unique constraint
SQL
0 vote299 views1 answer
Copy table dbeaver
SQL
0 vote388 views2 answers
Sql stored procedure for access frontend
SQL
0 vote351 views1 answer
Is not sql
SQL
0 vote390 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote365 views2 answers
Athena drop partition
SQL
0 vote347 views1 answer
Update using case in mysql
SQL
0 vote391 views1 answer
Sql max of two values
SQL
1 vote445 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote345 views1 answer
Mysql into outfile with headers
SQL