/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 vote249 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote267 views1 answer
Mysql not defined
SQL
0 vote288 views2 answers
List all constraints in postgres
SQL
0 vote269 views1 answer
How to print mysql query of codeigniter query builder
SQL
1 vote266 views1 answer
Adding a check statement in sql
SQL
0 vote263 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote284 views1 answer
Dump only data
SQL
-1 vote262 views1 answer
Mysql #1064 error
SQL
0 vote259 views1 answer
How to connect postgresql database with java
SQL
0 vote258 views1 answer
Oracle search columns in schema
SQL