/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 vote357 views1 answer
Rows to comma separated values in mssql
SQL
1 vote332 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote333 views1 answer
Groupby error in mysql
SQL
0 vote358 views1 answer
Sparql if bound query
SQL
0 vote334 views1 answer
Sql counter column
SQL
0 vote351 views1 answer
Ajax error exception handeling
SQL
1 vote386 views1 answer
Create new table from old table
SQL
2 votes390 views2 answers
Oracle create table if not exists
SQL
0 vote346 views1 answer
How to connect postgresql database with java
SQL
0 vote377 views1 answer
Sql delimiter to columns
SQL