Re: No duplicate records, ignore

[Nunya Beeznass]

Well, seems with a little effort, I found a way. I created a second new table to hold the 20 new records. Then I use the following insert select statement to add to processing table and truncate the holding table. I could probably do it with temp tables but I'm lazy and this works. Thanks tho

INSERT INTO exData (At,basecurid,Amount,Price,paircurid,Type)
SELECT n.At,n.basecurid,n.Amount,n.Price,n.paircurid,n.Type FROM exNewData n LEFT JOIN exData e on (n.At = e.At AND n.basecurid = e.basecurid and n.Price = e.Price and n.paircurid = e.paircurid) WHERE e.id IS NULL;
TRUNCATE exNewData;