/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

1 vote227 views1 answer
Display total number of tables in mysql
SQL
2 votes220 views2 answers
Mysql all columns
SQL
3 votes243 views2 answers
Tsql join multiple record in one string
SQL
0 vote231 views1 answer
How to set all the min and sec data to zero in sql server
SQL
6 votes222 views2 answers
Return columns from table sql
SQL
6 votes256 views2 answers
Oracle trigger
SQL
28 votes253 views4 answers
Delete database mysql
SQL
3 votes229 views3 answers
Mysql get table size
SQL
0 vote269 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
1 vote229 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL