MySQL 8.0

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

VALUES ROW (1, 'a'), ROW(2, 'b'), ROW(3, 'c') 


column_0
column_1


1
a

2
b

3
c


CREATE TABLE tab
AS 
SELECT 1 AS id

Records: 1  Duplicates: 0  Warnings: 0


SELECT *
FROM tab 
JOIN (VALUES ROW (1, 'a'), ROW(2, 'b'), ROW(3, 'c') ) sub(id, content)
  ON tab.id = sub.id


id
id
content


1
1
a