MySQL Tutorial Cast Functions Operators 9 codes

1 BINARY casts the string to a binary string

2 Cast Functions and Operators

3 CAST() also changes the result if you use it as part of a more complex expression such as CONCAT(Date

4 CAST() is useful for sorting ENUM columns in lexical order

5 CAST(expr AS type), CONVERT(expr,type), CONVERT(expr USING transcoding_name)

6 Convert blob column to char type

7 Converting the string abc in the default character set to the corresponding string in the utf8 character set

8 SELECT CAST(1 AS UNSIGNED) - 2 0

9 The cast functions are useful when you want to create a column with a specific type in a CREATE SELECT statement.