/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 vote321 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
1 vote322 views1 answer
ALL_TAB_PARTITIONS
SQL
19 votes347 views3 answers
How to change column type psql
SQL
-1 vote313 views1 answer
Ssms connect with connection string
SQL
0 vote304 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote333 views1 answer
Psql list rules
SQL
0 vote326 views1 answer
18446744073709551615 mariadb left join order by
SQL
1 vote336 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote311 views1 answer
Mysql local password denied
SQL
0 vote322 views1 answer
Vbscript clean up ADODB.Recordset
SQL