/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 vote161 views1 answer
Mysql group by derived column
SQL
0 vote187 views1 answer
Sql from null to not null
SQL
2 votes167 views1 answer
Guid to string sql
SQL
0 vote169 views1 answer
Hallo
SQL
4 votes157 views4 answers
Start mysql
SQL
0 vote157 views1 answer
Xampp mysql version
SQL
0 vote180 views1 answer
Find duplicate users by email address in mysql
SQL
2 votes153 views1 answer
Delete all value query
SQL
18 votes156 views6 answers
Create table mysql
SQL
0 vote164 views1 answer
Php get closest location by latitude longitude
SQL