/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 vote203 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote153 views2 answers
How to start postgresql laravel
SQL
21 votes167 views6 answers
Change column in mysql
SQL
1 vote166 views2 answers
Postgresql list columns
SQL
3 votes225 views3 answers
List columns in table postgres
SQL
2 votes196 views1 answer
Sql update \
SQL
3 votes160 views1 answer
Index using in query plsql
SQL
0 vote167 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote165 views1 answer
Dump only data
SQL
0 vote170 views1 answer
Sql drop procedure if exists
SQL