List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 5 2000 5:46pm
Subject:Re: Weird Results in 3.23.20-beta-log
View as plain text  
In the last episode (Sep 05), Boaz Yahav said:
> Hi Can anyone explain the phenomenon below?
>
> From: David Morfin [mailto:webmaster@stripped]
> > It seems that something funny is going on though.  What is clientID?
> > When I 'explain select bannerID from phpAds_adviews where bannerID=50;'
> > I get back
> > 
> > | table          | type  | possible_keys | key      | key_len | ref  | rows  |
> Extra                   |
> >
> +----------------+-------+---------------+----------+---------+------+-------+-------------------------+
> > | phpAds_adviews | range | clientID      | clientID |       3 | NULL | 54290 |
> where used; Using index |
> > 
> > Which I don't understand, since there isn't any clientID field that
> > I am aware of...  Is it perhaps a foriegn key that comes into play

Wwhat does a "show keys from phpAds_adviews" print?  The name of the
key may not match the name of the column(s) it is indexing.  The
"clientID" key is probably really be an index on bannerID.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Weird Results in 3.23.20-beta-logBoaz Yahav4 Sep
  • Re: Weird Results in 3.23.20-beta-logDan Nelson5 Sep