/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

1 vote324 views1 answer
Insert many to many sql
SQL
4 votes283 views1 answer
Psql get sequences
SQL
0 vote299 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote307 views1 answer
Mysql add text to existing field
SQL
-1 vote318 views1 answer
Minus vs except in sql
SQL
54 votes494 views6 answers
Sql rename column
SQL
0 vote318 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote319 views1 answer
Data directory postgresql
SQL
0 vote321 views1 answer
Sql server for loop
SQL
0 vote308 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL