From: Peter Brawley Date: July 20 2005 10:48pm Subject: Re: Make a report like this... List-Archive: http://lists.mysql.com/mysql/186751 Message-Id: <42DED4A2.8070702@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-42DED4A44D0C=======" --=======AVGMAIL-42DED4A44D0C======= Content-Type: multipart/alternative; boundary=------------020406080501030701010702 --------------020406080501030701010702 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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)? 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. > > > > --------------020406080501030701010702 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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)?

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.

--------------020406080501030701010702-- --=======AVGMAIL-42DED4A44D0C======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 7/19/2005 --=======AVGMAIL-42DED4A44D0C=======--