change data type in mysql
snippet in sql

alter table add column

user4162

ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;

alter table column in mysql

user1122


ALTER TABLE table_name

MODIFY column_name datatype; 

change data type in mysql

user6794

ALTER TABLE table_name

CHANGE COLUMN column_name column_name datatype; 

alter table

user9537


ALTER TABLE table_name

ADD column_name datatype;