MySQL 8.0

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

select version();


version()


8.0.36


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

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