Quote
rasikow Gnaniyar Wrote:
-------------------------------------------------------
> column 2 contains sometime 10 values or 20 values
> or 2 values separated by comma.
I'm not sure what the upper limit on GROUP_CONCAT is but I've seen it handle
30+.
I just tried it with 110 and it got them all :)
>
Had to wrap the para otherwise it'll go off side of the page -->
mysql> select group_concat(forumname) from mysqlforums;
| group_concat(forumname) |
| Announcements,Newbie,Install,Source, Builds, Binaries,Docs,QA,Sample
Database (Sakila),MySQL Migration Toolkit,Microsoft SQL
Server,Oracle,Sybase,IBM DB2,Informix,PostgreSQL,Firebird,SQLite,Microsoft
Access,DBF, dBASE, FoxPro, Clipper, xBASE,Other Migration,Knowledge
Base,MySQL Monitor,MySQL Query Analyzer,MySQL Load Balancer,MySQL
Proxy,Workbench - Newbie,Workbench - Database Modeling,Workbench - Schema
Compare, Diff, Synch,Workbench - DBDoc,Workbench - SQL Browser, Editor,
Refactor,Workbench - Source, Builds, Binaries,Workbench - Plugins &
Scripts,MySQL Query Browser,MySQL Administrator,Database
Administration,Database Design and Data Modelling,Reporting, Charting, and
BI,ODBC,.NET,JDBC and Java,MySQL Connector/C++,MySQL Connector/C
(libmysql),C/C++,C#, Mono,
.Net,Java,Delphi,Python,Perl,PHP,Ruby,XML,Falcon,Maria,MyISAM,InnoDB,Federated
Storage Engine,Archive Storage Engine,CSV Storage Engine,Memory Storage
Engine,Merge Storage Engine,Custom Storage Engines,memcached,Virtualization
Systems,MySQL on Amazon E |
1 row in set, 1 warning (0.00 sec)
mysql> notee
Thanks, Jay