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
