/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 vote162 views1 answer
Creating sqeuence in oracle database
SQL
0 vote120 views1 answer
Sql requete number pair
SQL
0 vote115 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote130 views1 answer
Systems sql
SQL
0 vote134 views1 answer
Time in sql server
SQL
0 vote129 views1 answer
Mysql update set sum
SQL
2 votes132 views2 answers
How to check data type in sql server
SQL
2 votes163 views1 answer
Oracle block
SQL
19 votes117 views4 answers
Rename database in sql
SQL
1 vote119 views1 answer
Oracle apex prevent initial load
SQL