add columns to table in mysql code example Example: mysql alter table add column ALTER TABLE vendors ADD COLUMN phone VARCHAR(15) AFTER name;