/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 vote105 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
24 votes141 views5 answers
Sql server insert into select
SQL
0 vote142 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
25 votes153 views5 answers
Uninstall mysql ubuntu
SQL
0 vote148 views1 answer
Insert into select with group by
SQL
0 vote192 views1 answer
Oracle temporary table
SQL
0 vote132 views1 answer
Test connection to sql server
SQL
0 vote147 views1 answer
Sql remove first character from string
SQL
2 votes137 views6 answers
In in sql
SQL
0 vote141 views1 answer
Hibernate show sql xml property
SQL