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

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

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

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

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

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

Examples related to mysql

Examples related to insert