/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 votes125 views1 answer
Scaffold npgsql net core
SQL
0 vote129 views1 answer
SQL loop with cursor
SQL
0 vote139 views1 answer
Sql server beginning of month
SQL
3 votes147 views1 answer
Oracle list invalid password logon denied
SQL
0 vote132 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
2 votes172 views2 answers
Null column to 0 in mysql
SQL
3 votes153 views3 answers
1396(hy00) mysql error
SQL
0 vote133 views1 answer
Sql query to delete row by id
SQL
0 vote142 views1 answer
Postgresql auto increment not working
SQL
2 votes131 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL