MySQL MIN函数为什么找到的不是最小的数

SQL code:

# SQL Manager 2007 Lite for MySQL 4.4.2.1
# ---------------------------------------
# Host : localhost
# Port : 3306
# Database : test


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;

SET FOREIGN_KEY_CHECKS=0;

DROP DATABASE IF EXISTS `test`;

CREATE DATABASE `test`
CHARACTER SET 'latin1'
COLLATE 'latin1_swedish_ci';

USE `test`;

#
# Structure for the `test` table :
#

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (
`id` int(20) default NULL,
`name` varchar(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `test` table (LIMIT 0,500)
#

INSERT INTO `test` (`id`, `name`) VALUES
(99999,'yu'),
(99998,'zhao'),
(99997,'lee'),
(36000,'zhang'),
(35999,'wang'),
(35998,'zhou');
COMMIT;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



select MIN(id) from test

结果：99997

这个MIN函数是什么原理

---

友情帮顶

MIN函数应该是取得最小值,然后放到产生的记录集的第一条