----- Original Message -----
> From: "Ananda Kumar" <[email protected]>
>
> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
