insert ignore into table (a,b) values (1,1),(1,2),(2,1),(2,2);
if a is pk or is a unique key, can I can reliably count on all statements NOT violating pk or unique constraint to be entered - even if they are AFTER the "violating" entry? i.e.: Do the non-duplicates get inserted and only the duplicates get "ignored" - no matter where they fall within the sql statement?
 
    