/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 vote127 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote123 views3 answers
Rename table snowflake
SQL
1 vote136 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote120 views2 answers
How to combine two sql queries in one result
SQL
1 vote136 views3 answers
Reset sql primary key
SQL
1 vote159 views1 answer
Oracle schema size
SQL
0 vote118 views1 answer
Stuff in sql server
SQL
0 vote133 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote131 views2 answers
Mysql select tables with name like
SQL
1 vote128 views1 answer
Mysql select update same table
SQL