MySQL ORDER BY 的几种排序算法 表结构 1 2 3 4 5 6 7 8 9 CREATE TABLE `t` ( `id` int(11) NOT NULL, `city` varchar(16) NOT NULL, `name` varchar(16) NOT NULL, `age` int(11) NOT NULL, `addr` varchar(128) DEFAULT NULL, PRIMARY KEY (`id`), KEY `city` (`city`) ) ENGINE=InnoDB; 全字段排序 1 mysql> select city,name,age from t where city