MySQL Update command

Question

I have a query in MySQL

UPDATE `mylandho_foreclosure`.`property_commercial` SET `winningBid` = '14000000.00' WHERE `property_commercial`.`propertyId` =325 LIMIT 1 ;

but it shows warning

Warning: #1264 Out of range value adjusted for column 'winningBid' at row 1

datatype is float(9,2)

Adriaan Stander · Accepted Answer · 2010-01-14 18:53:14Z

Float(9,2) would allow for 7 numbers before the decimal, and 2 after, you have 8 before and 2 after.

You need to increase the size of the filed if you wish to change the value to what you require.

You should have a look at Numeric Types

For example, a column defined as FLOAT(7,4) will look like -999.9999

Welcome to SO Rajanikant, don't forget to check this answer as the accepted one.

1 Answer 1