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, 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 ( > idt INT(8) NOT NULL AUTO_INCREMENT, > token CHAR(32), /* Ex: "New" OR "York" */ > PRIMARY KEY (idt), > UNIQUE KEY (token) > ); > > CREATE TABLE token2places ( > idt INT(8) NOT NULL, > idp INT(8) NOT NULL, > PRIMARY KEY (idt,idp) > ); __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
