/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 vote293 views1 answer
Deny select insert update delete sql
SQL
0 vote294 views1 answer
Mysql select all where count more than"
SQL
0 vote295 views1 answer
2020 new year
SQL
2 votes354 views2 answers
Null column to 0 in mysql
SQL
0 vote326 views1 answer
Sql server alter table add column tinyint
SQL
2 votes297 views1 answer
Select * from table where name like
SQL
7 votes281 views2 answers
Create mysql user
SQL
1 vote331 views2 answers
Extract weekday from date in sql
SQL
0 vote327 views1 answer
Insert ip address in mysql
SQL
0 vote314 views1 answer
How to make full text search dynamic in mysql
SQL