/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 vote220 views1 answer
No suitable driver found for sqlite
SQL
7 votes189 views3 answers
How to check table name in current database sql
SQL
7 votes317 views2 answers
Mysql default value
SQL
0 vote207 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote287 views1 answer
Sql trigger to call stored procedure with parameters
SQL
2 votes204 views1 answer
Mysql id of inserted row
SQL
2 votes200 views1 answer
Sqlite indexes
SQL
1 vote192 views1 answer
Right outer vs left outer join
SQL
12 votes214 views5 answers
Rename table in mysql
SQL
0 vote442 views1 answer
Power bi connect to postgresql
SQL