In MySQL i am inserting 80.23 in a datatype float (2,2). But i am getting error as : error 1264 Out of range value (column).

Question

Any help would be appreciated.

Answer 1

float(2,2) ==> two digits number with two decimals

So the range is -0.99 to 0.99

try float(4,2)