/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 vote217 views1 answer
Mariadb disable foreign key checks
SQL
0 vote161 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote189 views1 answer
Psql store procedure-return multiple table values
SQL
3 votes179 views2 answers
Truncate table
SQL
0 vote174 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote124 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
24 votes163 views2 answers
Alter table delete column
SQL
1 vote154 views1 answer
PLS-00225 type
SQL
1 vote170 views1 answer
Update and replace mysql
SQL
0 vote174 views1 answer
Convert excel into sqllite db using python
SQL