mysql error 1264 out of range value for column

Question

I'm using mysql workbench to management my database (mysql). I need to store a integer value that have more than 20 digits (we have 21 digits). I try to save in Bigint format but its not solve and i'm getting the same error:

mysql error 1264 out of range value for column

What is the best solution to save one integer with 21 digits?

BIGINT(21) doesnt mean you can save a INT with 21 digits.. read https://stackoverflow.com/questions/7142604/what-to-do-when-you-need-integers-larger-than-20-digits-on-mysql — Raymond Nijland, Jun 22 '17 at 09:20

Rohit Kumar · Answer 1 · 2017-06-22T09:30:51.207

1

You can make use of decimal datatype

The declaration syntax for a DECIMAL column is DECIMAL(M,D). The ranges of values for the arguments in MySQL 5.1 are as follows:

M is the maximum number of digits (the precision). It has a range of 1 to 65. (Older versions of MySQL permitted a range of 1 to 254.)

D is the number of digits to the right of the decimal point (the scale). It has a range of 0 to 30 and must be no larger than M.

Based on answer MySQL: Size of decimal data type

edited Jun 22 '17 at 09:30

answered Jun 22 '17 at 09:19

Rohit Kumar

776
3
21

Thanks for the replys ;) – rrpik93 Jun 26 '17 at 09:15

mysql error 1264 out of range value for column

1 Answers1