Hi
i am including table structure and other results to you
CREATE TABLE Mobile_Tunes
(
Tune_ID int(6) NOT NULL AUTO_INCREMENT,
Tune_Name varchar(30) NOT NULL,
Tune_Type varchar(10) NOT NULL,
PRIMARY KEY (Tune_ID),
UNIQUE KEY Tune_Name (Tune_Name),
INDEX Tune_Type (Tune_Type)
)ENGIN
Hi
i am including table structure and other results to you
CREATE TABLE Mobile_Tunes
(
Tune_ID int(6) NOT NULL AUTO_INCREMENT,
Tune_Name varchar(30) NOT NULL,
Tune_Type varchar(10) NOT NULL,
PRIMARY KEY (Tune_ID),
UNIQUE KEY Tune_Name (Tune_Name),
INDEX Tune_Type (Tune_Type)
)ENGIN
> > This shows you have NO indexes on the table. Assuming that 'Tune_Name'
> > contains unique entries for each row, I'd suggest you do the following
> > as a minimum:
> >
> > ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name);
>
> How's that going to help if he's getting all records from the t
On 9/11/07, Niel Archer <[EMAIL PROTECTED]> wrote:
> >
> > mysql> explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
> > +--+--+---+--+-+--+--+---+
> > | table| type | possible_keys | key | key_len | ref | rows |
> > Extra |
> > +---
>
> mysql> explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
> +--+--+---+--+-+--+--+---+
> | table| type | possible_keys | key | key_len | ref | rows |
> Extra |
> +--+--+---+--+-+--+-
Hi
this result is shown by mysql on running command prompt
mysql> explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+--+--+---+--+-+--+--+---+
| table| type | possible_keys | key | key_len | ref | rows |
Extra |
+-
Run the query through MySQL directly prepending EXPLAIN to the query
and attach the results here.
John
On 9/10/07, Asim <[EMAIL PROTECTED]> wrote:
> Hi
>
> i have added index on both columns but still same warning is issued by mysql
>
> then what i do now
>
> John Mertic <[EMAIL PROTECTED]> wrote
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now?
BYE
John Mertic <[EMAIL PROTECTED]> wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now
John Mertic <[EMAIL PROTECTED]> wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
Joh
Asim wrote:
Hi
in my script when i scan whole table for result set to display in my page it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim J
Hi
in my script when i scan whole table for result set to display in my page it
shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 3
11 matches
Mail list logo