mysql alter command code example
Example 1: add new column to the table mysql
ALTER TABLE `TABLE_NAME`
ADD `COLUMN_NAME` VARCHAR(50) NULL
AFTER `COLUMN_NAME_AFTER`;
Example 2: alter table mysql
ALTER TABLE contacts
ADD last_name varchar(40) NOT NULL
AFTER contact_id,
ADD first_name varchar(35) NULL
AFTER last_name;