/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

0 vote116 views1 answer
How to print sql query
SQL
8 votes114 views1 answer
Oracle create datafile
SQL
12 votes125 views2 answers
Delete entries in postgresql
SQL
0 vote116 views1 answer
Mysql server not starting in xampp in mac
SQL
1 vote129 views1 answer
Mysql breakline on string
SQL
0 vote73 views1 answer
Finish transaction sql
SQL
1 vote99 views1 answer
How to get mysql db size
SQL
8 votes131 views10 answers
Sql
SQL
0 vote115 views1 answer
Oracle job schedules
SQL
1 vote124 views1 answer
Error code 1175 mysql fix
SQL