MySQL skip the inserting into database when duplicate data inserting

Question

A B

Apple Pear
Apple Pear
Apple Pear
Orange Apple
Orange Beer
Cinder Punch

What is exactly the question ? – aleroot Mar 24 '12 at 09:37 — aleroot, Mar 24 '12 at 09:37
duplicate data means account all columns ? – Mar 24 '12 at 09:38 — , Mar 24 '12 at 09:38

score 3 · Answer 1 · edited May 23 '17 at 12:04

3

add unique index for (A,B) and try with:

INSERT IGNORE (A,B) VALUES (..)

You can also try to use ON DUPLICATE KEY UPDATE more here: "INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

edited May 23 '17 at 12:04

Community

answered Mar 24 '12 at 09:38

cichy