/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

16 votes333 views6 answers
Mysql find and replace
SQL
0 vote346 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote368 views1 answer
Postgresql inheritance
SQL
1 vote346 views1 answer
Sql select all from one table and one column from another
SQL
0 vote330 views1 answer
Which lock mode is not available in sql
SQL
0 vote328 views1 answer
Sql server count all tables rows
SQL
1 vote342 views1 answer
Tsql create unique index composite
SQL
0 vote352 views1 answer
Sql put two columns into one
SQL
1 vote353 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote345 views1 answer
Copy value from one column to another postgres
SQL