alter a column mysqçl code example

Example: mysql alter table add column

ALTER TABLE vendors ADD COLUMN phone VARCHAR(15) AFTER name;