CODEWITHSUNDEEP
mysqlsqlrow
Reimundo Heluani
Reimundo Heluani

Reputation: 978

SQL : splitting a row in two rows

I have a table that looks like this

|  ID  |   item1   |   item 2  | 
|   1  |     A1    |     B1    |
|   2  |     A2    |     B2    |

And I want to get something like this:

|  ID  |   item  |
|   1  |    A1   |
|   1  |    B1   |
|   2  |    A2   |
|   2  |    B2   |

In some sense it is the inverse to this SO question.

Upvotes: 2

Views: 56

Answers (1)

Giorgos Betsos
Giorgos Betsos

Reputation: 72225

Use UNION ALL:

SELECT ID, item1 AS item
FROM mytable

UNION ALL

SELECT ID, item2 AS item
FROM mytable
ORDER BY ID, item

Upvotes: 5

Related Questions