MySQL 8.0

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

CREATE TABLE table1 (Col1 CHAR(3), Col2 CHAR(3), Col3 CHAR(3));
INSERT INTO table1 VALUES
('R11',	'R12',	'R13'),
('R21',	'R22',	'R23'),
('R31',	'R32',	'R33'),
('R41',	'R42',	'R43');
SELECT * FROM table1;

Records: 4  Duplicates: 0  Warnings: 0




Col1
Col2
Col3


R11
R12
R13

R21
R22
R23

R31
R32
R33

R41
R42
R43


SELECT *
FROM table1
CROSS JOIN (
    SELECT 'A' col4, 'B' col5
    UNION ALL
    SELECT 'C', 'D'
    ) additional_table
ORDER BY 4,1;


Col1
Col2
Col3
col4
col5


R11
R12
R13
A
B

R21
R22
R23
A
B

R31
R32
R33
A
B

R41
R42
R43
A
B

R11
R12
R13
C
D

R21
R22
R23
C
D

R31
R32
R33
C
D

R41
R42
R43
C
D


CREATE TABLE table2 (Col1 CHAR(3), Col2 CHAR(3), Col3 CHAR(3), 
                     Col4 CHAR(1), Col5 CHAR(1))
SELECT Col1, Col2, Col3, Col4, Col5
FROM table1
CROSS JOIN (
    SELECT 'A' col4, 'B' col5
    UNION ALL
    SELECT 'C', 'D'
    ) additional_table;
SELECT * FROM table2 ORDER BY Col4, Col1;

Records: 8  Duplicates: 0  Warnings: 0




Col1
Col2
Col3
Col4
Col5


R11
R12
R13
A
B

R21
R22
R23
A
B

R31
R32
R33
A
B

R41
R42
R43
A
B

R11
R12
R13
C
D

R21
R22
R23
C
D

R31
R32
R33
C
D

R41
R42
R43
C
D

Col1	Col2	Col3	col4	col5
R11	R12	R13	A	B
R21	R22	R23	A	B
R31	R32	R33	A	B
R41	R42	R43	A	B
R11	R12	R13	C	D
R21	R22	R23	C	D
R31	R32	R33	C	D
R41	R42	R43	C	D

Col1	Col2	Col3	Col4	Col5
R11	R12	R13	A	B
R21	R22	R23	A	B
R31	R32	R33	A	B
R41	R42	R43	A	B
R11	R12	R13	C	D
R21	R22	R23	C	D
R31	R32	R33	C	D
R41	R42	R43	C	D

Col1	Col2	Col3	col4	col5
R11	R12	R13	A	B
R21	R22	R23	A	B
R31	R32	R33	A	B
R41	R42	R43	A	B
R11	R12	R13	C	D
R21	R22	R23	C	D
R31	R32	R33	C	D
R41	R42	R43	C	D

Col1	Col2	Col3	Col4	Col5
R11	R12	R13	A	B
R21	R22	R23	A	B
R31	R32	R33	A	B
R41	R42	R43	A	B
R11	R12	R13	C	D
R21	R22	R23	C	D
R31	R32	R33	C	D
R41	R42	R43	C	D

Col1	Col2	Col3	col4	col5
R11	R12	R13	A	B
R21	R22	R23	A	B
R31	R32	R33	A	B
R41	R42	R43	A	B
R11	R12	R13	C	D
R21	R22	R23	C	D
R31	R32	R33	C	D
R41	R42	R43	C	D

Col1	Col2	Col3	Col4	Col5
R11	R12	R13	A	B
R21	R22	R23	A	B
R31	R32	R33	A	B
R41	R42	R43	A	B
R11	R12	R13	C	D
R21	R22	R23	C	D
R31	R32	R33	C	D
R41	R42	R43	C	D