准备数据:tudou@gyyxmysql> show create table tmp\g
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tmp | CREATE TABLE `tmp` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`stat` enum('1','0','2') DEFAULT '1',
PRIMARY KEY (`id`),
KEY `ix_ics` (`stat`,`ctime`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3000001 DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------