/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 vote105 views1 answer
Psql kill pid
SQL
1 vote136 views1 answer
Sql upsert
SQL
0 vote142 views1 answer
SQL authentication error
SQL
0 vote142 views1 answer
Enable full text search mysql
SQL
2 votes137 views1 answer
Sql create database
SQL
0 vote130 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote140 views1 answer
Sql server list user permissions
SQL
7 votes138 views3 answers
How to check table name in current database sql
SQL
0 vote152 views1 answer
Mysql select all where count more than"
SQL
0 vote156 views1 answer
How to inner join 4 tables in sql
SQL