modify data type in mysql code example Example: alter table add column ALTER TABLE table ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;