/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 vote106 views1 answer
Sql sort column by date
SQL
0 vote108 views1 answer
Group by join columns per table
SQL
3 votes143 views3 answers
Create table in SQL Server
SQL
5 votes102 views2 answers
Get columns number sql
SQL
0 vote100 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
3 votes95 views1 answer
Mysql insert on dupèlicate
SQL
0 vote94 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
10 votes95 views4 answers
Primary key in sql
SQL
0 vote114 views1 answer
Sql order by except one row
SQL
1 vote99 views1 answer
How to select random rows from table
SQL