I used to have these issues in mysql version 5.0.41.
On Mon, May 14, 2012 at 8:13 PM, Johan De Meersman <vegiv...@tuxera.be>wrote: > ----- Original Message ----- > > From: "Ananda Kumar" <anan...@gmail.com> > > > > If numeric, then why are u using quotes. With quotes, mysql will > > ignore the index and do a full table scan > > Will it? Common sense dictates that it would convert to the column's > native type before comparing; and a quick explain seems to confirm this. > > That being said, it *is* better to use the actual column type from the > start, simply to avoid the cost of implicit conversions. > > > mysql> desc user; > > +-----------------+--------------+------+-----+-------------------+-----------------------------+ > | Field | Type | Null | Key | Default | Extra > | > > +-----------------+--------------+------+-----+-------------------+-----------------------------+ > | id | int(11) | NO | PRI | NULL | > auto_increment | > [...] > 16 rows in set (0.04 sec) > > mysql> explain select * from user where id = 1; > > +----+-------------+-------------------+-------+---------------+---------+---------+-------+------+-------+ > | id | select_type | table | type | possible_keys | key | > key_len | ref | rows | Extra | > > +----+-------------+-------------------+-------+---------------+---------+---------+-------+------+-------+ > | 1 | SIMPLE | user | const | PRIMARY | PRIMARY | > 4 | const | 1 | | > > +----+-------------+-------------------+-------+---------------+---------+---------+-------+------+-------+ > 1 row in set (0.07 sec) > > mysql> explain select * from user where id = '1'; > > +----+-------------+-------------------+-------+---------------+---------+---------+-------+------+-------+ > | id | select_type | table | type | possible_keys | key | > key_len | ref | rows | Extra | > > +----+-------------+-------------------+-------+---------------+---------+---------+-------+------+-------+ > | 1 | SIMPLE | user | const | PRIMARY | PRIMARY | > 4 | const | 1 | | > > +----+-------------+-------------------+-------+---------------+---------+---------+-------+------+-------+ > 1 row in set (0.00 sec) > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel >
