mysql cast colum value as int code example
Example 1: mysql parse int
SELECT CAST(PROD_CODE AS INT) FROM PRODUCTExample 2: mysql type conversion
MySQL Type Conversion
BINARY 'string'
CAST (expression AS datatype)
CONVERT (expression, datatype)SELECT CAST(PROD_CODE AS INT) FROM PRODUCTMySQL Type Conversion
BINARY 'string'
CAST (expression AS datatype)
CONVERT (expression, datatype)