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 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
