表结构:
CREATE TABLE `UserInfo` (
`Id` BIGINT(20) UNSIGNED NOT NULL COMMENT '唯一id',
`UserId` INT(10) UNSIGNED NOT NULL,
`Name` INT(10) UNSIGNED NOT NULL,
`Age` TINYINT(4) NOT NULL,
`CreateTime` DATETIME NOT NULL,
PRIMARY KEY (`Id`),
INDEX `Index 2` (`Age`, `CreateTime`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
sql语句,差别咋就这么大呢,待查资料分析原理...:
1):
SELECT Age,CreateTime FROM `UserInfo` where Age=18 ORDER BY CreateTime desc;
2):