/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 vote240 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote216 views1 answer
Postgresql isnull with max
SQL
11 votes222 views4 answers
MYSQL LOGIN
SQL
3 votes216 views2 answers
How to start postgresql on windows
SQL
1 vote227 views2 answers
Sql server find all foreign keys that reference a column
SQL
28 votes200 views4 answers
Mysql delete database
SQL
0 vote206 views1 answer
Sql server python connection
SQL
0 vote215 views1 answer
How to change mysql port in xampp
SQL
36 votes239 views3 answers
Add column in mysq
SQL
0 vote218 views1 answer
Guid string to binary better
SQL