/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 vote102 views1 answer
Mysql show category once count how many products
SQL
18 votes101 views3 answers
Mysql number format
SQL
28 votes106 views4 answers
Mysql delete database
SQL
11 votes112 views1 answer
How to get ddl for materialized view
SQL
-1 vote121 views3 answers
Error: mysql shutdown unexpectedly.
SQL
12 votes188 views2 answers
Find duplicates mysql column
SQL
0 vote259 views1 answer
Hue hive UploadingTextFiletoHive
SQL
15 votes113 views3 answers
Mysql update add to existing value
SQL
1 vote127 views1 answer
T-SQL / AZURE Reseed
SQL
2 votes111 views1 answer
Compare date in sql
SQL