insert ignore

 INSERT IGNORE INTO users (userid,username) VALUES (2,'swan'),(4,'bear') ;

---
Query OK, 1 row affected, 1 warning (0.02 sec)
Records: 2  Duplicates: 1  Warnings: 1