Hello.
On Mon, May 27, 2002 at 10:31:52AM -0700, [EMAIL PROTECTED] wrote:
> Is this approach still of use if many more tables are
> added?
As I said (in the not-quoted part) "[This] is the standard approach
for implementing a M to N relationship."
> so basically you create a lot of 'relations'
Is this approach still of use if many more tables are
added?
so basically you create a lot of 'relations' tables to
store key relations rather than store the relation in
each table?
olinux
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> If FULLTEXT indexes are out of question, wha
Hi.
If FULLTEXT indexes are out of question, what your suggestion is the
way to go. Although I would usually use an additional table:
CREATE TABLE places (
idp INT(8) NOT NULL,
place CHAR(32), /* Ex: "New York" */
PRIMARY KEY(idp)
);
CREATE TABLE tokens (
