How to get the mysql table columns data type?

You can use the information_schema columns table:

SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
  WHERE table_name="tbl_name" AND COLUMN_NAME = 'col_name';