MySQL 8.0

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

select version();


version()


8.0.27


CREATE TABLE table1(a INTEGER, b INTEGER, c INTEGER);

INSERT INTO table1 VALUES
    (1,1,1),
    (1,1,2),
    (1,1,3),
    (1,2,1),
    (1,2,2),
    (1,2,3),
    (1,3,1),
    (1,3,2),
    (1,3,3);
SELECT *
FROM (VALUES ROW(1),ROW(2))l


column_0


1

2


SELECT *
FROM table1
CROSS JOIN (VALUES ROW(1),ROW(2))x


a
b
c
column_0


1
1
1
2

1
1
1
1

1
1
2
2

1
1
2
1

1
1
3
2

1
1
3
1

1
2
1
2

1
2
1
1

1
2
2
2

1
2
2
1

1
2
3
2

1
2
3
1

1
3
1
2

1
3
1
1

1
3
2
2

1
3
2
1

1
3
3
2

1
3
3
1

a	b	c	column_0
1	1	1	2
1	1	1	1
1	1	2	2
1	1	2	1
1	1	3	2
1	1	3	1
1	2	1	2
1	2	1	1
1	2	2	2
1	2	2	1
1	2	3	2
1	2	3	1
1	3	1	2
1	3	1	1
1	3	2	2
1	3	2	1
1	3	3	2
1	3	3	1

a	b	c	column_0
1	1	1	2
1	1	1	1
1	1	2	2
1	1	2	1
1	1	3	2
1	1	3	1
1	2	1	2
1	2	1	1
1	2	2	2
1	2	2	1
1	2	3	2
1	2	3	1
1	3	1	2
1	3	1	1
1	3	2	2
1	3	2	1
1	3	3	2
1	3	3	1

a	b	c	column_0
1	1	1	2
1	1	1	1
1	1	2	2
1	1	2	1
1	1	3	2
1	1	3	1
1	2	1	2
1	2	1	1
1	2	2	2
1	2	2	1
1	2	3	2
1	2	3	1
1	3	1	2
1	3	1	1
1	3	2	2
1	3	2	1
1	3	3	2
1	3	3	1