Mysql database converts the varchar type to the int type, mysqlvarchar

Mysql database converts the varchar type to the int type, mysqlvarchar

In the previous article, I introduced the slow query caused by converting int to varchar In the MySQL database. This article describes how to convert varchar to int In the Mysql database. Let's take a look!

Mysql provides two types of conversion functions: CAST and CONVERT. How can we let go of the ready-made stuff?

CAST () and CONVERT () functions can be used to obtain values of one type and generate values of another type.

This type can be one of the following values:

BINARY[(N)]CHAR[(N)]DATEDATETIMEDECIMALSIGNED [INTEGER]TIMEUNSIGNED [INTEGER]

So we can also use CAST to solve the problem:

select server_id from cardserver where game_id = 1 order by CAST(server_id as SIGNED) desc limit 10

You can also use CONVERT to solve this problem:

select server_id from cardserver where game_id = 1 order by CONVERT(server_id,SIGNED) desc limit 10

PS:

Mysql varchar type conversion int type

 select * from gyzd_yysinfo order by cast(yysid as SIGNED INTEGER)

Or

select * from gyzd_yysinfo order by cast(yysid as UNSIGNED INTEGER)

The above section describes how to convert the varchar type to the int type in Mysql database. I hope it will be helpful to you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!