Converted to bigint mysql varchar type-CodePudding

Home > database > Converted to bigint mysql varchar type

Converted to bigint mysql varchar type

Time：10-04

A 24-bit digital string varchar, converted to int not long enough, can only be converted to bigint, convert and cast function does not support this turn, there are other ways to turn?

CodePudding user response:

 
Select the CAST (' 123456781234567812345678 'AS a Decimal (24))

Page link：https//www.codepudding.com/database/50413.html

Prev:When the same query command set Heidi and Mysql client return character set parameters of different?

Next:How to solve the three framework configuration files without prompt?

Tags：

MySQL

Links：
CodePudding