Last answered:

10 Dec 2021

Posted on:

29 Oct 2021


fIXED AND Floating point numbers

What of cases when I set the datatype as DECIMAL(5, 3) and i imput a number like  543.6?

Will it throw an error?

1 answers ( 0 marked as helpful)
Posted on:

10 Dec 2021


Hi Promise!

Thanks for reaching out.

Yes, it will show you an error 1264 – out of range value for column. You should insert a value with 5 digits and three after the decimal point. Something like this: 53.345. This record will be fine.

Hope this helps.

Submit an answer