/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

7 votes251 views1 answer
Minecraft forge server host
SQL
1 vote274 views2 answers
Procedure syntax
SQL
0 vote278 views2 answers
Sql day from datetime
SQL
5 votes257 views1 answer
Mysql count newlines in field
SQL
0 vote243 views1 answer
Call function sql oracle with output put line
SQL
3 votes253 views2 answers
Brew start mysql
SQL
93 votes324 views4 answers
Create database postgres
SQL
0 vote274 views1 answer
Create user faunadb
SQL
1 vote267 views2 answers
Sql server concat string and int
SQL
0 vote238 views1 answer
Low level operator in dbms
SQL