/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

0 vote257 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote252 views1 answer
Sum values by month mariadb
SQL
0 vote244 views1 answer
SQL Server modify_timestamp trigger
SQL
11 votes272 views6 answers
Distinct sql
SQL
11 votes265 views1 answer
Oracle view source
SQL
0 vote244 views1 answer
Sql query to delete row by id
SQL
0 vote253 views1 answer
Mysql procedure between two tables
SQL
0 vote325 views1 answer
Python get backup of sql
SQL
0 vote286 views2 answers
How to drop mili second in sql
SQL
0 vote290 views1 answer
How to get button for every record from mysql
SQL