在MySql中按列名将单个记录分成两行

Question

我想通过列名将单个记录分成两个记录。

只考虑单一的纪录了。

目前我所得到使用简单的选择查询：

{ "id" : "1", "route_name" : "6", "start_up" : "Mumbai", "destination_up" : "Delhi", "start_down" : "Delhi", "destination_down" : "Mumbai" } 

我真的需要：

{ "id" : "1", "route_name" : "6", "start_up" : "Mumbai", "destination_up" : "Delhi" }, { "id" : "1", "route_name" : "6", "start_down" : "Delhi", "destination_down" : "Mumbai" } 

我怎样才能做到这一点使用单个查询？

Answer 1

你可以使用一个工会

select id, route_name, start_up, destination_up 
    from my_table 
    where id ='1' 
    union 
    select id, route_name, start_down, destination_down 
    from my_table 
    where id ='1'