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)
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.
Best,
Martin