/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 vote170 views1 answer
Mysql money value
SQL
1 vote178 views1 answer
How to change owner in postgres
SQL
0 vote161 views1 answer
How to create an SQL save method in ruby
SQL
0 vote194 views1 answer
Convert polygon to text in mysql
SQL
13 votes184 views2 answers
Get tables in database sql
SQL
0 vote209 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote220 views1 answer
Stop and start mysql
SQL
0 vote185 views1 answer
How to write if case in select query in select statement
SQL
0 vote284 views1 answer
Sqlite woth cmake
SQL
0 vote231 views2 answers
Mysql select date from datetime
SQL