/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

4 votes205 views1 answer
Change nls_date_format
SQL
16 votes221 views5 answers
Select last row in sql
SQL
8 votes214 views1 answer
Oracle search stored procedures for text
SQL
4 votes205 views1 answer
Data types in sql
SQL
0 vote212 views1 answer
Changing name of column and datatype in sql
SQL
0 vote204 views1 answer
Postgresql default value boolean
SQL
1 vote247 views3 answers
Divide by zero error in sql
SQL
0 vote189 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote192 views3 answers
Mysql calculate age from date of birth
SQL
0 vote198 views2 answers
Sqlite unix timestamp
SQL