/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 vote186 views1 answer
Sql oracle update multiple rows
SQL
-1 vote130 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote136 views1 answer
Postgres float to int
SQL
1 vote135 views1 answer
Oracle db create new schema
SQL
1 vote127 views1 answer
Set id count mysql
SQL
7 votes151 views2 answers
N highest salary in sql
SQL
7 votes126 views1 answer
Forge server hosting
SQL
0 vote153 views2 answers
Starts and end with vowel sql
SQL
2 votes146 views2 answers
Laravel query builder toSql
SQL
1 vote147 views1 answer
Count mysql server db tables
SQL