Mysql, reshape data from long / tall to wide

by

Cross-tabs or pivot tables is the answer. From there you can SELECT FROM … INSERT INTO … or create a VIEW from the single SELECT.

Something like:

SELECT country, 
       MAX( IF( key='President', value, NULL ) ) AS President,
       MAX( IF( key='Currency', value, NULL ) ) AS Currency,
       ...

FROM table 
GROUP BY country;

More Related Contents:

  1. Simple way to calculate median with MySQL
  2. Join vs. sub-query
  3. Find records from one table which don’t exist in another
  4. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  5. Natural Sort in MySQL
  6. MySQL get row position in ORDER BY
  7. Subqueries vs joins
  8. MySQL Results as comma separated list
  9. MySQL unknown column in ON clause
  10. MySQL not using indexes with WHERE IN clause?
  11. SQL: Find the max record per group [duplicate]
  12. Group by month and year in MySQL
  13. calculate a sum of type time using sql
  14. MySQL: Transactions vs Locking Tables
  15. Remove duplicates using only a MySQL query?
  16. Group by date only on a Datetime column
  17. Finding the next available id in MySQL
  18. How exactly does using OR in a MySQL statement differ with/without parentheses?
  19. MySQL: How to copy rows, but change a few fields?
  20. How to renumber primary index
  21. Query that ignore the spaces
  22. Is it possible to have a default parameter for a mysql stored procedure?
  23. mysql automatically store record creation timestamp
  24. update columns values with column of another table based on condition [duplicate]
  25. MySQL GROUP BY behavior
  26. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  27. Update multiple rows with one query?
  28. How to find all IDs of children recursively?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment