MySql 1366 Error Incorrect Integer Value

MySQL 1366 Error Incorrect Integer Value for Column 'columnname' at Row 1

I'm pulling my hair out. I need some sweet, head-bangin' distortion after this one.

I could have sworn my query was working earlier but now it's not. So i logged in phpmyadmin and ran my query and it returned this error.

The actual column is an int(11) and set to NULL and default value is 0.

The column is usually going to be left blank so it can be empty. Therein lies the problem when the query runs without any value for my column it returns the 1366 error.

I just don't understand why this is happening to a NULL field. Moreover, when the value is empty it should default to 0 anyway and populate the column. Right? So what is the incorrect integer value?

Can anybody shed some light on this issue for me?

How exactly does your SQL query looks? If it has variables in there, keep those variables in there (In the PHP).

@devilwood

when it's empty it'll add null and not 0

and for integer i have encountered that problem, it works sometimes

it's better to use VARCHAR with NULL or INT with NOT NULL and default value 0

My query was just a straight forward insert like



My apologies for not being more thorough with my explanation as that would have helped, but dark_lord picked up what I was getting at since he's yanked his hair out on this one already too. I think he's got me fixed up if all I got to do is change the field to NOT NULL.

indeed, it returns true