Re: Question about combination PRIMARY keys and INDEX

2005-04-20 Thread Paul DuBois
At 9:10 +1000 4/21/05, Daniel Kasak wrote: Daevid Vincent wrote: If I have a table with a primary key like this: CREATE TABLE `answers` ( `qid` INT UNSIGNED NOT NULL , `userid` INT UNSIGNED NOT NULL , `groupid` INT UNSIGNED NOT NULL , `comments` TEXT NOT NULL , PRIMARY ( `qid` , `userid` , `groupi

Re: Question about combination PRIMARY keys and INDEX

2005-04-20 Thread Daniel Kasak
Daevid Vincent wrote: >If I have a table with a primary key like this: > >CREATE TABLE `answers` ( >`qid` INT UNSIGNED NOT NULL , >`userid` INT UNSIGNED NOT NULL , >`groupid` INT UNSIGNED NOT NULL , >`comments` TEXT NOT NULL , > PRIMARY ( `qid` , `userid` , `groupid` ) >); > >But I will also be s

Question about combination PRIMARY keys and INDEX

2005-04-20 Thread Daevid Vincent
If I have a table with a primary key like this: CREATE TABLE `answers` ( `qid` INT UNSIGNED NOT NULL , `userid` INT UNSIGNED NOT NULL , `groupid` INT UNSIGNED NOT NULL , `comments` TEXT NOT NULL , PRIMARY ( `qid` , `userid` , `groupid` ) ); But I will also be searching in various pages, for all