/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 vote281 views1 answer
Install squirrel sql ubuntu
SQL
0 vote325 views1 answer
Parent and child link in mysql
SQL
0 vote263 views1 answer
Mysql begin statement
SQL
0 vote292 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote229 views1 answer
Postgres grant read only access to database
SQL
0 vote280 views1 answer
Ksql quickstart docker
SQL
8 votes290 views2 answers
Phpmyadmin default password
SQL
0 vote276 views1 answer
Sql add calculated column
SQL
21 votes280 views4 answers
Oracle add column
SQL
1 vote273 views3 answers
Mysql disable foreign keys check
SQL