By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.27 |
CREATE TABLE tags (
tag_id int primary key,
tag_name varchar(100)
);
CREATE TABLE products (
product_id int primary key,
product_name varchar(100)
);
INSERT INTO tags VALUES
(1 , 'Wunderbar!'),
(2 , 'Brand-new'),
(3 , 'Electrified');
INSERT INTO products VALUES
(1 , 'Go-karts'),
(2 , 'Rocketsleds'),
(3 , 'Turbopants'),
(4 , 'Sporks');
CREATE TABLE product_tags (
id int primary key auto_increment,
tag_id int not null,
product_id int not null
);
INSERT INTO product_tags ( tag_id, product_id )
SELECT tag_id, product_id
FROM tags
CROSS JOIN products
WHERE (tag_name, product_name) IN (
('Electrified', 'Sporks'),
('Electrified', 'Rocketsleds'),
('Wunderbar!', 'Turbopants')
);
SELECT * FROM product_tags
| id | tag_id | product_id |
|---|---|---|
| 1 | 3 | 2 |
| 2 | 1 | 3 |
| 3 | 3 | 4 |