Artificially add a record to MySQL results

Question

Is there a way to skip the record at the top of the result set in MySQL? For example, if my results are:

1 | a
2 | b
3 | c
etc

I want to receive:

Select | Select
1 | a
2 | b
3 | c
etc

Where "Select" is not really part of the recordset, but artificially inserted.

Thanks.

Answer 1

The only way to achieve this with a query is to use UNION:

SELECT 'Select', 'Select'
UNION
SELECT ...

The correct ordering will depend on how you want the results to be ordered in general.

, ( ) , .

Answer 2

SELECT "Select" as col1, "Select" as col2
UNION
SELECT col1, col2 FROM table

Answer 3

If your request

SELECT Colum1, Column2 FROM Table

to try

SELECT Column1, Column2 from the UNION SELECT table "Select", "Select"

Answer 4

Union.

select "Select", "Select"
union
select Col1, Col2 from Table1