CODEWITHSUNDEEP
mysqlmysql-error-1264
Rajanikant
Rajanikant

Reputation: 1

MySQL Update command

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)

Upvotes: 0

Views: 303

Answers (1)

Adriaan Stander
Adriaan Stander

Reputation: 166326

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

Upvotes: 5

Related Questions