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