Incorrect integer value for column id at row 1

Question

I am trying to insert into my mySQL database  The first column is the  id  column  since its an auto increment field  I left it blank  For some reason  I am unable to insert and I am getting the error mentioned below  I appreciate any help with this   I am getting the following error while trying to insert   Incorrect integer value     for column  id  at row 1   my query    insertQuery    INSERT INTO workorders VALUES       priority     requestType     purchaseOrder     nte     jobSiteNumber

User · Answer

For the same error in wamp phpmyadmin  I have edited my ini  commented the original     sql-mode   STRICT ALL TABLES ERROR FOR DIVISION BY ZERO NO ZERO DATE NO ZERO IN DATE NO AUTO CREATE USER    and added sql mode

User · Answer

To let MySql generate sequence numbers for an AUTO INCREMENT field you have three options    specify list a column list and omit your auto incremented column from it as njk suggested  That would be the best approach  See comments   explicitly assign NULL explicitly assign 0    3 6 9  Using AUTO INCREMENT         No value was specified for the AUTO INCREMENT column  so MySQL   assigned sequence numbers automatically  You can also explicitly   assign NULL or 0 to the column to generate sequence numbers    These three statements will produce the same result     insertQuery    INSERT INTO workorders   priority    request type   VALUES   priority     requestType           insertQuery    INSERT INTO workorders VALUES NULL    priority           insertQuery    INSERT INTO workorders VALUES 0    priority

User · Answer

Try to edit your my cf and comment the original sql mode and add sql mode        vi  etc mysql my cnf      sql mode        save and quit     service mysql restart

User · Answer

This is because your data sending column type is integer and your are sending a string value to it   So  the following way worked for me  Try with this one    insertQuery    INSERT INTO workorders VALUES                       null                        priority                         requestType                         purchaseOrder                         nte                         jobSiteNumber                        Don t use  null   use it as null without single quotes

User · Answer

That probably means that your id is an AUTO INCREMENT integer and you re trying to send a string  You should specify a column list and omit it from your INSERT   INSERT INTO workorders  column1  column2  VALUES   column1   column2

[mysql] Incorrect integer value: '' for column 'id' at row 1

Examples related to mysql

Examples related to insert