/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 vote172 views1 answer
Sql insert query list of dictionaries
SQL
0 vote156 views2 answers
Oracle select
SQL
0 vote144 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
7 votes142 views1 answer
Oracle set sequence value to max(id)
SQL
-1 vote146 views1 answer
How to check table exists or not in postgresql
SQL
2 votes149 views1 answer
Columns Present in a table
SQL
0 vote155 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote149 views1 answer
Mysql count with two joins
SQL
1 vote156 views1 answer
Sql count value greater than
SQL
0 vote138 views1 answer
Mssql current date
SQL