1
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?

kaya3
  • 47,440
  • 4
  • 68
  • 97
Jann
  • 2,214
  • 3
  • 28
  • 45

1 Answers1

1

I did more research and found this answer to another StackOverflow question:

...and now some multiple row tests

Thanks to Paulus Maximus

Jann
  • 2,214
  • 3
  • 28
  • 45