感谢回复 可能是 数据太少了
表结构和索引如下:
mysql> desc smsreceive;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| ID | bigint(20) | NO | PRI | NULL | auto_increment |
| SRCMOBILE | varchar(30) | YES | MUL | NULL | |
| DESTMOBILE | varchar(30) | YES | | NULL | |
| RETURNDATE | datetime | YES | MUL | NULL | |
| MSGID | varchar(45) | YES | MUL | NULL | |
| MSGCONTENT | varchar(300) | YES | | NULL | |
| STATUS | varchar(30) | YES | | NULL | |
| VOTESTATUS | varchar(45) | YES | | NULL | |
| CHECKSTATUS | varchar(45) | YES | | NULL | |
| MODIUSERID | varchar(45) | YES | | NULL | |
| MODIUSERNAME | varchar(45) | YES | | NULL | |
| MODIDATE | datetime | YES | | NULL | |
| OLDCONTENT | varchar(300) | YES | | NULL | |
+--------------+--------------+------+-----+---------+----------------+
13 rows in set (0.09 sec)
mysql> show index from smsreceive;
+------------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed |
+------------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+
| smsreceive | 0 | PRIMARY | 1 | ID | A | 53 | NULL | NULL |
| smsreceive | 1 | IDX_SRCMOBILE | 1 | SRCMOBILE | A | 53 | NULL | NULL |
| smsreceive | 1 | IDX_MSGID | 1 | MSGID | A | 53 | NULL | NULL |
| smsreceive | 1 | IDX_RETURNDATE | 1 | RETURNDATE | A | 53 | NULL | NULL |
+------------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+
4 rows in set (0.00 sec)