/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 vote302 views1 answer
Shortcut run sql pgadmin
SQL
0 vote277 views1 answer
Mysql installer no packages found
SQL
0 vote305 views1 answer
Check user sql password from command line
SQL
0 vote287 views1 answer
Sql contains numeric characters
SQL
0 vote278 views1 answer
Get first monday of month sql
SQL
0 vote287 views1 answer
Postgresql comandos basicos
SQL
41 votes370 views6 answers
Alter table add column in SQL Server
SQL
3 votes275 views3 answers
Sql current year
SQL
1 vote336 views1 answer
Import sql file from laravel
SQL
7 votes300 views1 answer
Mysql iif
SQL