/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

7 votes189 views2 answers
Oracle sql drop index
SQL
1 vote216 views1 answer
Nullif postgresql
SQL
0 vote169 views1 answer
IIF
SQL
1 vote182 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote173 views1 answer
Use between operator in mysql
SQL
0 vote174 views1 answer
Cannot start database server xampp mac os
SQL
-1 vote218 views1 answer
Difference berween database and data base management system
SQL
0 vote185 views1 answer
Sql remove first character from string
SQL
1 vote181 views2 answers
Drop function in sql
SQL
0 vote222 views1 answer
How to subquey to do not load in live database in
SQL