Incorrect integer value: '' for column 'id' SQL error

Posted under » MySQL on 10 Jan 2022

You are trying to insert into my mySQL database. The first column is the 'id' column, since its an auto_increment field, you left it blank. You are unable to insert and are getting the 'incorrect integer' error.

That probably means that your id is an AUTO_INCREMENT integer and you're trying to send a string. You should assign NULL to the id column.

Or if you are lazy, you can just change or add to your mysql settings.

sql_mode = ""