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?