By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
version() |
---|
8.0.36 |
create table numbers_api (id int auto_increment primary key, email varchar(100), name varchar(100));
create unique index idx on numbers_api (email, name);
Records: 0 Duplicates: 0 Warnings: 0
INSERT IGNORE INTO numbers_api (email, name) VALUES ('A', 'A');
INSERT IGNORE INTO numbers_api (email, name) VALUES ('A', 'A');
INSERT IGNORE INTO numbers_api (email, name) VALUES ('B', 'B');
INSERT IGNORE INTO numbers_api (email, name) VALUES ('A', 'A');
INSERT IGNORE INTO numbers_api (email, name) VALUES ('B', 'B');
INSERT IGNORE INTO numbers_api (email, name) VALUES ('C', 'C');
select * from numbers_api;
id | name | |
---|---|---|
1 | A | A |
3 | B | B |
6 | C | C |