Getting duplicate key error: See log where the INSERT query error is

[riahc3]

I have a bunch of insert querys running and some of them fail with a duplciate entry.

I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated.

Thanks

[rch1231]

Hello,

Try INSERT IGNORE in place of INSERT and it will ignore the duplicate key errors.

[diafol]

mysql_query($sql); //or use mysqli equivalents
if (mysql_errno() == 1062) {
    echo "Duplicate key error: <pre><code>$sql</code></pre>";
}

[riahc3]

I went ahead with REPLACE but thank you

And this isnt a PHP question.

[diafol]

No prob. I assumed that you wanted to log these specific fails in a custom log file. So where 'echo', you could just append the SQL to a text file instead.

With REPLACE - be aware of a few things...

http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update (selected answer).