Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "sample analysis of conversion functions and sorting problems in mysql", which is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and study the "sample analysis of conversion functions and sorting problems in mysql".

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

The CAST () and CONVERT () functions can be used to get a value of one type and produce a value of another type.

This type can be one of the following values:

BINARY [(N)]

CHAR [(N)]

DATE

DATETIME

DECIMAL

SIGNED [INTEGER]

TIME

UNSIGNED [INTEGER]

Use cast (the field to be converted as UNSIGNED) to generate a UNSIGNED/SIGNED number. This function is a bit like a collection of functions such as to_char,to_number,to_date in oracle.

The above is all the contents of the article "sample Analysis of conversion functions and sorting problems in mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.