Inserting records in Mysql with INSERT IGNORE and NULL values?

This is how NULL works. Keep in mind that the result of equality comparison of two NULL values is NULL (which evaluates to FALSE in logical expressions). So even if you have a unique constraint on column Field1 that allows NULL value, the table can have more than 1 record where the value of Field1 is NULL.

If you want to treat NULL differently, in addition to unique constraint you need to write BEFORE INSERT/UPDATE triggers which check if there is a record in the table where Field1 IS NULL (and raise an error to prevent updating).

Thanks! – Homer1980ar Jun 13 '10 at 18:12.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.