/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 vote197 views1 answer
Sqlalchemy order by descending
SQL
1 vote189 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote204 views2 answers
Compound operator in sql
SQL
0 vote206 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote200 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote198 views1 answer
Sql server update top n records
SQL
0 vote267 views1 answer
Alter database name script
SQL
17 votes258 views6 answers
Get last record in sql
SQL
1 vote194 views2 answers
How to drop a unique constraint in sql
SQL
0 vote202 views1 answer
Sqlite3 update select
SQL