Home
Arjen's Journal - 11th May 2008
Open Query: MySQL, Open Source & other ponderings

Arjen Lentz
Date: 2008-05-11 22:55
Subject: From normalised schema to spreadsheet
Security: Public

Here's one for you... imagine you have a properly normalised schema, but you need to output it to CSV for a spreadsheet. So, you have multiple attributes for each item. The number of items is larger than the max # of joins (61) that you can do in MySQL. How to do this in a single query?

5 Comments | Post A Comment | Add to Memories | Tell a Friend | Link



browse
my journal
links
July 2008
High Performance MySQL (2nd ed.)
summary