mysql查询类型转换_MySQL

mysql> explain select * from user where name=1/G

*************************** 1. row ***************************           id: 1  select_type: SIMPLE        table: user         type: ALLpossible_keys: index_name_password          key: NULL      key_len: NULL          ref: NULL         rows: 99727        Extra: Using where1 row in set (0.02 sec)mysql> explain select * from user where name='1'/G

*************************** 1. row ***************************           id: 1  select_type: SIMPLE        table: user         type: refpossible_keys: index_name_password          key: index_name_password      key_len: 111          ref: const         rows: 1        Extra: Using where1 row in set (0.00 sec)