Convert varchar column to int in MySQL

Following is the script to convert a varchar datatype column to int type:

ALTER TABLE `YourTableName` MODIFY `YourColumnName` INT NULL;

You can further verify the column data type with the help of this blog: Check column data type in mysql