On Wed, Jan 31, 2001 at 08:50:44PM +0100, leo.putz wrote :
> Sorry for having to post the same problem a second time -
> but by now I'm really at a loss.
> Is there really no one out there to give me a hint?
>
> I need the output of a query result (all query information is in one
> row) in one c
If i get it right, you should use CONCAT
- Original Message -
From: leo.putz <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 10:50 PM
Subject: Once again ... row to column conversion
> Sorry for having to post the same problem a second time -
> but by now I
Yeah, you should really change the way the database is setup but you
could also do something like this. Have perl return an array and just do
a foreach on the array and that will give you all the values of each
column on the row, without you knowing how many rows there are.
Even if your not usin
Change the way it's stored in the table.
Seriously, if the data is stored in a single row, there is no way via SQL
(not defined in standards, not available in any SQL server implementation
I've seen either), then the program has to convert that into columns. The
standard mysql utility is capable
