Incorrect integer value
by Ramya[ Edit ] 2010-10-08 10:40:21
MySQL Bug : Incorrect integer value
while inserting the values into the table as,
mysql> insert into test values('','abhi','muthu','srija');
I recived this error message as ,
Incorrect integer value
Then i tried inserting like,
mysql> insert into test('name1','name2','name3') values('abhi','muthu','srija');
It worked out........
As '' for id is not an integer, it showed the error message. Hence either use NULL for id or better specify the fields and values for the specified fields alone........
