give table
CREATE TABLE `people` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`age` smallint(6) DEFAULT NULL,
`birth` date DEFAULT '1990-01-01',
`sex` enum('m','f') DEFAULT NULL,
PRIMARY KEY (`id`),
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8
add index for sex;
alter table people add index sex(sex);
using index;