/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 vote383 views2 answers
SQL FROM
SQL
1 vote349 views1 answer
How to truncate a table in databse
SQL
8 votes392 views1 answer
Oracle search stored procedures for text
SQL
0 vote354 views1 answer
How to check xampp mysql password
SQL
0 vote341 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
4 votes361 views1 answer
Group by mysql and concatenate string
SQL
1 vote348 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote355 views1 answer
Alter table myisam to innodb
SQL
7 votes357 views6 answers
Nth highest salary in sql
SQL
8 votes466 views1 answer
Mysql dump restore
SQL