MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (id int primary key, somefield varchar(10))
Insert into t(id, somefield) values (1,'foo'),(2,'bar'),(1,'foo'),(3,'bob')
Duplicate entry '1' for key 't.PRIMARY'

select * from t;
Insert ignore into t(id, somefield) values (1,'foo'),(2,'bar'),(1,'foo'),(3,'bob')
select * from t


id
somefield


1
foo

2
bar

3
bob