SQLite 3.27

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

CREATE TABLE tags(tag TEXT, url TEXT);
✓
CREATE UNIQUE INDEX tag_url ON tags (tag, url);
✓
INSERT INTO tags(tag, url) VALUES ('tag1', 'url1');
✓
INSERT INTO tags(tag, url) VALUES ('tag1', 'url1'); 
ON CONFLICT(tag, url) IGNORE

{}


INSERT INTO tags(tag, url) VALUES ('tag1', 'url1')
ON CONFLICT(tag, url) DO NOTHING
✓
SELECT * FROM tags;


tag
url


tag1
url1


INSERT OR IGNORE INTO tags(tag, url) VALUES ('tag1', 'url1');
✓
SELECT * FROM tags;


tag
url


tag1
url1