/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 vote142 views1 answer
Mysql query to check record exists in database table or not
SQL
9 votes136 views3 answers
Mysql get last id
SQL
0 vote139 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote158 views2 answers
Postgres having
SQL
1 vote154 views1 answer
Full sql mode
SQL
9 votes136 views3 answers
Show table columns mysql command line
SQL
0 vote148 views1 answer
Mysql date only no time
SQL
3 votes128 views1 answer
MySQL DELETE JOIN
SQL
0 vote146 views1 answer
Sql server user permissions and roles
SQL
23 votes147 views4 answers
Sql server substring
SQL