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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]