/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

1 vote258 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote185 views1 answer
Online sql testing tool
SQL
0 vote186 views1 answer
Mysql show category once count how many products
SQL
0 vote262 views1 answer
Postgres select from values
SQL
16 votes199 views3 answers
Tsql rename column name
SQL
0 vote261 views1 answer
Bash block size ls /var/lib/mysql
SQL
8 votes197 views3 answers
Postgres connection string
SQL
2 votes256 views1 answer
Select a certain number of entries from select mysql
SQL
1 vote229 views3 answers
How to create a table structure from another table in mysql
SQL
1 vote207 views3 answers
Rows, INSERT INTO
SQL