当重复数据插入[关闭]时，MySQL跳过插入数据库

A B

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

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"