Bonjour, you simply cannot do this. In SQL, every column has one value, everything else is not normalized, and normalization is required in relational dbms. If you want to have such a list, you would need to do it in you application, given it's a (PHP,Java etc) application accessing the database. Stefan
Am Wednesday 17 March 2004 17:09 schrieb Richard Carlier: > Bonjour, > > "Horizontal" is not the word but I don't know how to explain... and by > extension how to find in archive of list... > > Maybe an example ? > > I have this > +-------+-------+ > > | a | b | > > +-------+-------+ > > | 1 | 1 | > | 1 | 2 | > | 1 | 3 | > | 2 | 1 | > | 2 | 2 | > | 3 | 1 | > > +-------+-------+ > > Their is any why to obtain something like that : > +-------+--------+ > > | a | b | > > +-------+--------+ > > | 1 | 1,2,3 | > | 2 | 1,2 | > | 3 | 1 | > > +-------+--------+ > > Based on a group by or something... > > A + -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
