/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 vote137 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote128 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote132 views1 answer
How to insert multiple rows in mysql using laravel
SQL
3 votes156 views4 answers
Mysql create table from select statement
SQL
0 vote129 views1 answer
PostgreSQL types and C# types
SQL
3 votes250 views6 answers
Sql unique select
SQL
0 vote146 views1 answer
Ubuntu connect to mssql database
SQL
1 vote136 views1 answer
Full sql mode
SQL
0 vote123 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote159 views1 answer
Tsql cte in a transaction
SQL