Data not inserted in BIGINT datatype of mySQL-CodePudding

Home > database > Data not inserted in BIGINT datatype of mySQL

Data not inserted in BIGINT datatype of mySQL

Time：06-23

I am trying to insert following data in BIGINT datatype but it is given an error "Out of range value for column 'bts' at row 1"

Data: 110121014322232000011

Please help how to insert this data to mySQL table. I am using mySQL 5.7.21

CodePudding user response：

Surely ...

signed (2)63 =     9223372036854776000
unsigned (2)64 =  18446744073709552000
Your number      110121014322232000011