Click to See Complete Forum and Search --> : mysql 5.x issue


DARTHTAMPON
04-02-2007, 09:46 PM
INSERT INTO cars( year, make, model, zeroToSixty, quarterMile )
VALUES ( 1988, 'Audi', '80', 9.6, 17.1 )

MySQL said:

#1264 - Out of range value adjusted for column 'quarterMile' at row 1

How do I get around this. I know that from reading around that I need to comment out a line in my.ini but I am on a shared hosting plan and they will not allow me to edit the file. That said how do I get around this?

I have tried adding quotes to the 2 decimals but that does not help.

tia

pcthug
04-02-2007, 10:06 PM
Moved to SQL Forum.