/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 vote268 views1 answer
Mysql insert into select with recursive
SQL
0 vote267 views1 answer
Set a default value for a column in sqlite
SQL
2 votes286 views1 answer
How to delete columns in sql
SQL
0 vote285 views1 answer
Mysql change innodb to myisam
SQL
1 vote283 views1 answer
Base64 encode sql server
SQL
8 votes321 views2 answers
Default sql server port
SQL
4 votes274 views3 answers
Postgres set default value
SQL
0 vote257 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
2 votes277 views1 answer
Postgresql left join distinct on
SQL
1 vote282 views1 answer
Incompatible sql_mode=only_full_group_by
SQL