ALTER TABLE `TABLE_NAME` ADD `COLUMN_NAME` VARCHAR(50) NULL AFTER `COLUMN_NAME_AFTER`;
ALTER TABLE table_name ADD column_name datatype;
ALTER TABLE table_name ALTER COLUMN column_name datatype;