/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 vote115 views1 answer
Mysql query problems and solutions
SQL
0 vote97 views1 answer
Sql get month and year from date
SQL
1 vote122 views1 answer
Sql first day quarter
SQL
0 vote111 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
3 votes109 views1 answer
Set default today mysql
SQL
6 votes132 views2 answers
Clear a table in mysql
SQL
2 votes145 views1 answer
How to select from mssql
SQL
0 vote105 views1 answer
Case when with count and combining similar values in sql
SQL
7 votes124 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote117 views1 answer
Oracle synonym procedure dblink
SQL