By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.30 |
CREATE TABLE product_attr (
product_attr_id INT NOT NULL AUTO_INCREMENT,
attr_7 INT NOT NULL,
attr_29 INT NOT NULL,
PRIMARY KEY (product_attr_id)
);
INSERT INTO product_attr (attr_7, attr_29)
WITH RECURSIVE
param AS
(
SELECT
461 AS attr_7_start, -- начальное значение для attr_7
10 AS attr_7_num, -- количество итераций в attr_7
1097 AS attr_29_start, -- начальное значение для attr_29
3 AS attr_29_num -- количество итераций в attr_29
),
attr29_iter (n) AS
(
SELECT 0
UNION ALL
SELECT n + 1 FROM attr29_iter, param WHERE n < attr_29_num -1
),
attr_7_iter (n) AS
(
SELECT 0
UNION ALL
SELECT n + 1 FROM attr_7_iter, param WHERE n < attr_7_num -1
),
gen_inc AS
(
SELECT i7.n as inc7, i29.n as inc29
FROM attr_7_iter i7, attr29_iter i29
)
SELECT attr_7_start + inc7, attr_29_start + inc29
FROM gen_inc, param
ORDER BY 1,2
;
Records: 30 Duplicates: 0 Warnings: 0
SELECT * FROM product_attr;
| product_attr_id | attr_7 | attr_29 |
|---|---|---|
| 1 | 461 | 1097 |
| 2 | 461 | 1098 |
| 3 | 461 | 1099 |
| 4 | 462 | 1097 |
| 5 | 462 | 1098 |
| 6 | 462 | 1099 |
| 7 | 463 | 1097 |
| 8 | 463 | 1098 |
| 9 | 463 | 1099 |
| 10 | 464 | 1097 |
| 11 | 464 | 1098 |
| 12 | 464 | 1099 |
| 13 | 465 | 1097 |
| 14 | 465 | 1098 |
| 15 | 465 | 1099 |
| 16 | 466 | 1097 |
| 17 | 466 | 1098 |
| 18 | 466 | 1099 |
| 19 | 467 | 1097 |
| 20 | 467 | 1098 |
| 21 | 467 | 1099 |
| 22 | 468 | 1097 |
| 23 | 468 | 1098 |
| 24 | 468 | 1099 |
| 25 | 469 | 1097 |
| 26 | 469 | 1098 |
| 27 | 469 | 1099 |
| 28 | 470 | 1097 |
| 29 | 470 | 1098 |
| 30 | 470 | 1099 |