/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 vote124 views1 answer
How to connect to xampp sql server on windows cmd
SQL
13 votes63 views2 answers
Oracle all source
SQL
3 votes105 views2 answers
Oracle for loop
SQL
-1 vote127 views2 answers
Postgres autoincrement primary key
SQL
0 vote121 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
1 vote114 views1 answer
Sql headers delphi
SQL
0 vote114 views1 answer
Set classpath for mysql-connector.jar
SQL
3 votes107 views1 answer
Ssh check mysql version
SQL
1 vote123 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote136 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL