[TYPO3-english] DB Select

[Roberto Torresani]

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 <kraftb at kraftb.at>

> 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
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>