Hi,

while trying to handle severl key values,
I wonder if it is more efficient to put
those values in a row seperated by a
certain seperator (eg. comma).

The talbe has two fields and looks like;

UID ForeinID
1     2,3,4,6
2    7,9,4,5
3    3,4
4    1,5,7,9
5    2,3,4,5

and the values of ForeignID is primary keys
of another table.

What would be the best way to handle this kind of
case (i.e. M-to-M relationship) in MySQL?

Thanks in advance.

Lingua

Reply via email to