How to use mysql to express one line in multiple lines

Question

I have the following mysql table.

  a  | b  | c
1 a1 | b1 | c1

I would like to use a SQL query to create a table like the one below:

  time | sessionCnt
1 a    | a1
2 b    | b1
3 c    | c1

I tried this:

SELECT
  'a1' AS a,
  'b1' AS b,
  'c1' AS c
FROM dual;

Possible duplicate of [MySQL pivot table](https://stackoverflow.com/questions/7674786/mysql-pivot-table) — waka, Jan 25 '18 at 13:58
@FrankerZ, your rollback from OP's revision 3 from yours (revision 2) should be cancelled. Tables should not be posted as images but as text. Also, this query formatting is weird and hard to read. — Adrien Brunelat, Jan 25 '18 at 13:59
Can you give me the mysql query by using the above dual table? — hwkang, Jan 25 '18 at 14:06

score 0 · Answer 1 · answered Jan 25 '18 at 14:18

0

Try this:

select 'a' as time, 'a1' as sessionCnt
union
select 'b', 'b1'
union
select 'c', 'c1';

answered Jan 25 '18 at 14:18

Pavel Katiushyn

1 Answers1