MySQL row and column conversion stitching

Mysql> select Tbl_id,create_time,last_access_time,tbl_name,tbl_type from TBLs;

+--------+-------------+------------------+----------------------+---------------+

| tbl_id | Create_time | Last_access_time | Tbl_name | Tbl_type |

+--------+-------------+------------------+----------------------+---------------+

|  6 |                1437309077 | 0 | Students | managed_table |

|  11 |                1437402612 | 0 | User_info_bucketed_1 | managed_table |

+--------+-------------+------------------+----------------------+---------------+

2 rows in Set (0.00 sec)

Mysql> Select Tbl_id,create_time,last_access_time,tbl_name,tbl_type from TBLs \g;

1. Row ***************************

Tbl_id:6

create_time:1437309077

last_access_time:0

Tbl_name:students

Tbl_type:managed_table

2. Row ***************************

Tbl_id:11

create_time:1437402612

last_access_time:0

Tbl_name:user_info_bucketed_1

Tbl_type:managed_table

2 rows in Set (0.00 sec)

Mysql> select * from User_info;

+---------+-----------+-----------+

| user_id | FirstName | LastName |

+---------+-----------+-----------+

| 100 | Hadoop | Spark01 |

| 100 | Hadoop | Spark02 |

| 100 | Hadoop | Spark03 |

| 200 | Hive | Python2.6 |

| 200 | Hive | Python2.7 |

| 200 | Hive | Python3.3 |

| 200 | Hive | Python3.4 |

| 300 | HBase | Pig |

| 300 | HBase | Zoo |

+---------+-----------+-----------+

9 Rows in Set (0.00 sec)

Mysql> Select user_id,group_concat (FirstName) from User_info Group by user_id;

+---------+-------------------------+

| user_id | Group_concat (FirstName) |

+---------+-------------------------+

| 100 | Hadoop,hadoop,hadoop |

| 200 | hive,hive,hive,hive |

| 300 | Hbase,hbase |

+---------+-------------------------+

3 Rows in Set (0.06 sec)

Mysql> Select user_id,group_concat (LastName) from User_info Group by user_id;

+---------+-----------------------------------------+

| user_id | Group_concat (LastName) |

+---------+-----------------------------------------+

| 100 | spark01,spark02,spark03 |

| 200 | python2.6,python2.7,python3.3,python3.4 |

| 300 | Pig,zoo |

+---------+-----------------------------------------+

3 Rows in Set (0.00 sec)

Mysql> Select user_id,group_concat (LastName separator '; ') from User_info Group by user_id;

+---------+-----------------------------------------+

| user_id |    Group_concat (LastName separator '; ') |

+---------+-----------------------------------------+

| 100 | SPARK01; Spark02; Spark03 |

| 200 | Python2.6; Python2.7; Python3.3; Python3.4 |

| 300 | Pig; Zoo |

+---------+-----------------------------------------+

3 Rows in Set (0.00 sec)

Mysql> Select user_id,group_concat (LastName ORDER BY lastname DESC Separator ' # ') from User_info Group by user _id;

+---------+-------------------------------------------------------------+

| user_id | Group_concat (LastName ORDER BY lastname DESC Separator ' # ') |

+---------+-------------------------------------------------------------+

| 100 | spark03#spark02#spark01 |

| 200 | python3.4#python3.3#python2.7#python2.6 |

| 300 | Zoo#pig |

+---------+-------------------------------------------------------------+

3 Rows in Set (0.00 sec)

MySQL row and column conversion stitching