CODE EXAMPLE FOR SQL

mysql add column to table

ALTER TABLE contacts
  ADD last_name varchar(40) NOT NULL
    AFTER contact_id;