List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:September 2 2008 12:48am
Subject:RE: Impossible WHERE in explain
View as plain text  
The key_len column indicates the length of the key that MySQL decided to use. The length
is NULL if the key column says NULL. Note that the value of key_len allows you to
determine how many parts of a multiple-part key MySQL will actually use.
i do not know the definition of parameter 'ken_len'Martin
______________________________________________ Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender.
This transmission is of a confidential nature and Sender does not endorse distribution to
any party other than intended recipient. Sender does not necessarily endorse content
contained within this transmission. > Date: Tue, 2 Sep 2008 02:05:00 +0530> From:
prajapatikc@stripped> To: brenttech@stripped> Subject: Re: Impossible WHERE in
explain> CC: mysql@stripped> > I have already tried. It's not working.>
> On Tue, Sep 2, 2008 at 1:55 AM, Brent Baisley <brenttech@stripped> wrote:>
> > It might be because you you are comparing user_id to a string, when the> >
field type is a decimal. Drop the quotes around the user_id search value and> > see
if that works.> >> > Brent Baisley> >> >> > On Sep 1, 2008,
at 3:59 PM, Krishna Chandra Prajapati wrote:> >> > Hi,> >>>
>> In the query below explain gives 'Impossible WHERE noticed after'. what>
>> does> >> this mean.> >>> >> CREATE TABLE `user_cookie`
(> >> `user_id` decimal(22,0) NOT NULL default '0',> >> `param`
varchar(128) NOT NULL default '',> >> `value` varchar(128) default NULL,>
>> PRIMARY KEY (`user_id`,`param`),> >> CONSTRAINT `fk_user_cookie` FOREIGN
KEY (`user_id`) REFERENCES> >> `user_info` (`user_id`) ON DELETE NO ACTION ON
UPDATE NO ACTION> >> ) ENGINE=InnoDB DEFAULT CHARSET=latin1> >>>
>> SELECT VALUE FROM user_cookie WHERE USER_ID = '10538485' AND PARAM => >>
'TIMEOUT' table |type |possible_keys |key | ken_len|ref | rows| 1> >> |SIMPLE | |
| | | |Impossible WHERE noticed afte> >> --> >> Krishna Chandra
Prajapati> >>> >> >> > > -- > Krishna Chandra Prajapati
_________________________________________________________________
Be the filmmaker you always wanted to be—learn how to burn a DVD with Windows®.
http://clk.atdmt.com/MRT/go/108588797/direct/01/
Thread
Impossible WHERE in explainKrishna Chandra Prajapati1 Sep
  • Re: Impossible WHERE in explainBrent Baisley1 Sep
    • Re: Impossible WHERE in explainKrishna Chandra Prajapati1 Sep
      • RE: Impossible WHERE in explainMartin Gainty2 Sep
        • Re: Impossible WHERE in explainKrishna Chandra Prajapati2 Sep
  • Re: Impossible WHERE in explainJim Lyons1 Sep