ptember 10, 2004 7:18 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Breaking table columns into separate rows
When you say "report" what exactly do you mean? In the client., have you
looked at using \G and not ; to terminate your queries?
Why not transform your data struc
First, I think your data structure is wrong. Like data should be in a
single column, like an attribute column. This provides scalability (no
limit on attributes) and efficiency (no empty columns).
But, since you are probably stuck with what you have, try something
like this:
SELECT CONCAT(KeyF
When you say "report" what exactly do you mean? In the client., have you
looked at using \G and not ; to terminate your queries?
Why not transform your data structure and keep only one column of data, as
you suggested?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL
