/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 vote92 views1 answer
Check if due date is less than todays date sql
SQL
2 votes132 views1 answer
Cast string to datetime mysql
SQL
0 vote90 views4 answers
Sql limit 1 offset 1
SQL
6 votes168 views3 answers
Rename column ORACLE
SQL
0 vote134 views1 answer
Update table sql multiple set
SQL
2 votes132 views1 answer
Change primary key sql
SQL
1 vote140 views2 answers
Sql server concat string and int
SQL
2 votes132 views1 answer
Q operator in plsql
SQL
1 vote126 views4 answers
Sequelize migration default value
SQL
0 vote127 views1 answer
18446744073709551615 mariadb left join order by
SQL