/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

11 votes334 views2 answers
Sql between date range
SQL
0 vote350 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
1 vote331 views1 answer
MySQL AND Operator
SQL
0 vote378 views2 answers
Sql day from datetime
SQL
0 vote334 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote369 views1 answer
Search In the Database using Text
SQL
0 vote365 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote338 views1 answer
Json_remove mysql
SQL
4 votes344 views4 answers
Update select mysql
SQL
0 vote361 views1 answer
Python list from sql
SQL