Insert into table with multiple select statements in MY SQL

Question

I have the result from a query like:

+------------------+------------+ | meta_key | meta_value | +------------------+------------+ | Destination Name | Shivapuri | | Destination Date | 26/03/2012 | +------------------+------------+

I am trying to write a select statement with the Column name as Destination Name and Destination Date whose respective values are Shivapuri and '26/03/2012'. How is this possible to do with a query in MY SQL?

This is called a pivot table and has been answered many times before on SO: stackoverflow.com/questions/7674786/mysql-pivot-table — liquorvicar
– liquorvicar, Commented Apr 6, 2012 at 11:12
Pivot is rather unneeded, Since by the nature of the structure, there is only going to be one destination name and destination date. — Starx
– Starx, Commented Apr 6, 2012 at 11:27

user1191247 · Accepted Answer · 2012-04-06 11:44:26Z

Something along these lines should do it -

SELECT GROUP_CONCAT(IF(meta_key = 'Destination Name', meta_value, NULL)) AS `Destination Name`, GROUP_CONCAT(IF(meta_key = 'Destination Date', meta_value, NULL)) AS `Destination Date` FROM tbl_name GROUP BY record_identifier

Starx · Accepted Answer · 2012-04-06 11:48:27Z

SELECT (CASE WHEN meta_key = 'Destination Name' THEN meta_value END) as name, (CASE WHEN meta_key = 'Destination Date' THEN meta_value END) as date FROM `yourtable`

Collectives™ on Stack Overflow

Insert into table with multiple select statements in MY SQL

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related