Thank to all for the answer. My question born from how kickstarter build database and relations. I understood that is better a m-m relations :).... there is not something, that i don't know, in TYPO3 that permit to query relation with comma.
Thanks Roberto 2009/10/6 Bernhard Kraft <[email protected]> > Jan Bednarik schrieb: > > Hi, > > > >> Example Table 2 > >> uid;name;category > >> 1;name1;1,2 > >> 2;name2;2 > >> 3;name3;1,2,3 > > > > this is wrong databse design, that violates even the first normal form > > (see http://en.wikipedia.org/wiki/Database_normalization) > > > > Yes. Roberto, you should really think about redesigning your database. > Using comma-separated values for relations is not really the way to go. > You can use comma separated values, if you do not need to join those > values directly by an SQL query - which is exactly what you asked. > > so better go on and read the article about database-normalization or buy > a good book about data structures and database design. > > > greets, > Bernhard > > > _______________________________________________ > TYPO3-english mailing list > [email protected] > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english > _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
