INSERT IGNORE - IGNORED?

[Mike Puerto]

Hi,

I have a PHP script that imports CSV files into a table... it works fine... My question is...

When using INSERT IGNORE I know that the duplicates will be ignored but, is there anyway to see exactly what was ignored? Or better yet, any way to insert the ignored into a separate table? If this is not possible just using MySQL, is anyone aware of a way to grab the ignored via PHP?

or is it possible to import to a temp db, and then run some sort of statement that will merge the rows that do not already have an existing id in the database... the statement would add rows with ids that are not already in there and remove them from the temp table and keep the rows that already have existing ID's... If that even makes sense...

Thanks so much!
Mike



Edited 1 time(s). Last edit at 10/27/2009 07:53PM by Mike Puerto.