/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

9 votes343 views1 answer
No sql
SQL
1 vote325 views1 answer
Sample clause in sql
SQL
0 vote275 views1 answer
Get last run query sql server
SQL
0 vote349 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
4 votes317 views1 answer
What are the data types in sql
SQL
6 votes323 views2 answers
Join vs union
SQL
0 vote305 views1 answer
Get first name and last name from full name string in SQL
SQL
1 vote322 views1 answer
Apex select list ORA-20999
SQL
0 vote362 views1 answer
Implode in sql query
SQL
0 vote336 views1 answer
Mysql server not starting in xampp in mac
SQL