MySQL: Select from list of values

Question

I was wondering if I could select given values from a list and populate rows? For example, SELECT 1 as one, 2 as two, 3 as three will populate columns:

one    | two    | three
------------------------
1      | 2      | 3

I'm looking for a script that populates rows, something like:

values
-------
1
2
3
4

Thanks!

Answer 1

you can union each one if you want like so

SELECT 1 AS numbers
UNION SELECT 2
UNION SELECT 3

a much simpler way to do something like this would be to make a table with an auto incremented id... insert into another column in the table an empty string... then just select the auto incremented id

CREATE TEMPORARY TABLE tmp (
    id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
    val  varchar(1) 
);
INSERT INTO tmp (val)
values
(""),
(""),
(""),
(""),
(""),
(""),
(""),
(""),
(""),
("");
select id from tmp;

DEMO