/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

38 votes232 views4 answers
Count sql
SQL
0 vote194 views0 answer
How to connect to datbase in springboot
SQL
0 vote218 views1 answer
Check index sql server
SQL
1 vote239 views3 answers
Sql select only time from datetime
SQL
0 vote238 views4 answers
Rownum in sql
SQL
4 votes248 views1 answer
Oracle error line
SQL
4 votes274 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
1 vote247 views2 answers
Mysql allow remote connections
SQL
0 vote248 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote310 views2 answers
Mysql insert rows to another database
SQL