/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

2 votes179 views1 answer
How to add where command in update comand with joins
SQL
0 vote191 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote185 views1 answer
Sql create table with datetime automatically
SQL
4 votes227 views1 answer
Rename stored procedure in sql server
SQL
13 votes179 views2 answers
Check if value is null mysql
SQL
4 votes185 views4 answers
Start mysql
SQL
0 vote186 views1 answer
Sql select non unique
SQL
0 vote185 views1 answer
Mariadb search columns
SQL
1 vote176 views3 answers
Java.sql.sqlexception: access denied for user
SQL
1 vote246 views1 answer
Insert pg result of select
SQL