Select multiple rows in a MySQL row

Question

Possible duplicate:
Can you define "literals" in SQL?

Sometimes I find myself in a situation where I would like to join an existing table to the table of values ​​entered in the query. Sort of:

SELECT ((1,2,3),(4,5,6)); 

If the query returns two rows of 3 columns. Obviously, this syntax is incorrect, but this way you can create one row of data. For instance:

SELECT 1,2,3;

Is there a way to do what I'm trying to achieve?

Answer 1

SELECT 1,2,3
UNION ALL
SELECT 4,5,6;