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. >> >> >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
