tended recipient.
> Sender does not necessarily endorse content contained within this
> transmission.
>
>
> > Date: Tue, 2 Sep 2008 02:05:00 +0530
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > Subject: Re: Impossible WHERE in explain
> > C
other than intended recipient.
Sender does not necessarily endorse content contained within this transmission.
> Date: Tue, 2 Sep 2008 02:05:00 +0530> From: [EMAIL PROTECTED]> To: [EMAIL
PROTECTED]> Subject: Re: Impossible WHERE in explain> CC:
mysql@lists.mysql.com> > I have
I just tried this. I got the same results *until* I inserted a record that
met the criteria. SInce the values are for a primary key, EXPLAIN could see
there was no such entry and so reported that. If you actually execute the
command, you would not see an error, just no rows returned. EXPLAIN wa
I have already tried. It's not working.
On Tue, Sep 2, 2008 at 1:55 AM, Brent Baisley <[EMAIL PROTECTED]> 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
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 'Impossib
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`),
CONSTRA
