/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

1 vote396 views1 answer
Mariadb get column names from table
SQL
0 vote341 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote292 views1 answer
Oracle sql developer script output limit
SQL
0 vote358 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote372 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote340 views1 answer
Mysql grant access to one database
SQL
0 vote305 views2 answers
Influxdb delete measurement based on date
SQL
5 votes338 views1 answer
How to check port number for postgresql
SQL
0 vote325 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote332 views1 answer
H2 auto increment and unique
SQL