/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 vote198 views2 answers
Sql stored procedure for access frontend
SQL
1 vote131 views1 answer
Metada in sql
SQL
0 vote215 views1 answer
Sqlite3 not commit
SQL
0 vote185 views1 answer
Postgress append string in select
SQL
0 vote170 views1 answer
Oracle select invalid views
SQL
0 vote225 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote179 views1 answer
Assign value to var in SQL
SQL
3 votes205 views2 answers
Mysql select database
SQL
0 vote186 views4 answers
User defined function sql
SQL
2 votes189 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL