Check out example codes for "mysql show column data types". It will help you in understanding the concepts better.

Code Example 1

SELECT DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where
table_schema = ’yourDatabaseName’ and table_name = ’yourTableName’.

Learn ReactJs, React Native from akashmittal.com