/SQL/How to add more columns to a table in mysql

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

21 votes200 views6 answers
Update sql
SQL
0 vote148 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
6 votes159 views1 answer
Oracle rank
SQL
1 vote205 views1 answer
Connect to mysql database ubuntu
SQL
0 vote281 views1 answer
Mysql delete entire row on condition
SQL
0 vote281 views2 answers
Mysql insert rows to another database
SQL
3 votes151 views1 answer
Create a table with an id in mysql
SQL
1 vote201 views1 answer
Mysql connect command
SQL
4 votes153 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote160 views1 answer
Mysql insert into select with recursive
SQL