/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 vote344 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
9 votes354 views3 answers
Mysql run sql file
SQL
10 votes361 views2 answers
Tsql merge example
SQL
0 vote318 views1 answer
Joins vs includes
SQL
0 vote344 views1 answer
Sql last 3 rows
SQL
0 vote344 views1 answer
How to update date value in sql
SQL
5 votes353 views1 answer
Sql table columns
SQL
9 votes339 views6 answers
Check constraint in sql
SQL
0 vote307 views1 answer
Sql comparison operators
SQL
0 vote339 views1 answer
Mariadb cast null to 0
SQL