List:General Discussion« Previous MessageNext Message »
From:Dan Bolser Date:July 20 2005 10:58pm
Subject:Re: Make a report like this...
View as plain text  
On Wed, 20 Jul 2005, Peter Brawley wrote:

>Dan
>
>/>Hello, I made the above report by hand after using a GROUP_CONCAT
> >query. Is there any way to make this kind of format automatically in
> >MySQL?/
>
>How about HTML output (mysql ... -H)?

Yeah, I found that works, for example also with 

'GROUP_CONCAT( ... SEPARATOR = "<br>")'

I was just looking for a text based report if possible. It seems it should
be do-able in perl or similar, but I don't know if it has.

Cheers,


>
>PB
>
>------
>
>Dan Bolser wrote:
>
>>+------+-------+----+----+-------------------------------------+
>>| G_ID | TOTAL | G2 | NR | ASSEMBLY_LISTING                    |
>>+------+-------+----+----+-------------------------------------+
>>| 1132 |    34 |  1 |  1 | 1bf3-1,1bgj-1,1bgn-1,1bkw-1,1cc4-1, |
>>|      |       |    |    | 1cc6-1,1cj2-1,1cj3-1,1cj4-1,1d7l-1, |
>>|      |       |    |    | 1dob-1,1doc-1,1dod-1,1doe-1,1ius-1, |
>>|      |       |    |    | 1k0i-1,1k0j-1,1k0l-1,1pbb-1,1pbc-1, |
>>|      |       |    |    | 1pbd-1,1pbe-1,1pbf-1,1pdh-1,1phh-1, |
>>|      |       |    |    | 1pxa-1,1pxb-1,1pxc-1,2phh-1         |
>>+------+-------+----+----+-------------------------------------+
>>| 1793 |    10 |  1 |  1 | 1jdx-1,2jdw-1,2jdx-1,3jdw-1,4jdw-1, |
>>|      |       |    |    | 5jdw-1,6jdw-1,7jdw-1,8jdw-1,9jdw-1  |
>>+------+-------+----+----+-------------------------------------+
>>
>>
>>Hello, I made the above report by hand after using a GROUP_CONCAT
>>query. Is there any way to make this kind of format automatically in
>>MySQL?
>>
>>It seems it would be a nice feature.
>>
>>Dan.
>>
>>
>>  
>>
>

Thread
Make a report like this...Dan Bolser21 Jul
  • Re: Make a report like this...Peter Brawley21 Jul
    • Re: Make a report like this...Dan Bolser21 Jul
  • Re: Make a report like this...Greg Fortune21 Jul