mysql-error-1264

specify what columns not to insert values into mysql table

I have a stored procedure that inserts a row into a table with an autoincremented column. It gives me a warning but succeeds if i simply put "" for the value of the autoincremented column. The way I get rid of the error currently is to specify which columns the insert values are for... "insert into app_table(app_id,name,...) values(...)"...

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) ...