Incorrect integer value - Mysql Views : 288
Tagged in : Mysql
0 0
Send mail
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........Razz

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........
By Ramya, On - 2010-10-08



    Login to add Comments .