Code in this package first appeared on the O'Reilly Network on July 23, 2004.
by Paul Meagher <paul@datavore.com>
Last modified March 31 2006 @ 1:23 pm UTC
Demos:
Source code listing:
CREATE TABLE `TestScores` (
`id` int(11) NOT NULL auto_increment,
`anxiety` enum('low','moderate','high') NOT NULL default 'low',
`score` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `anxiety` (`anxiety`)
) TYPE=MyISAM;
#
# Dumping data for table `TestScores`
#
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (1, 'low', 26);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (2, 'low', 34);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (3, 'low', 46);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (4, 'low', 48);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (5, 'low', 42);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (6, 'low', 49);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (7, 'low', 74);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (8, 'low', 61);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (9, 'low', 51);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (10, 'low', 53);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (11, 'moderate', 51);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (12, 'moderate', 50);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (13, 'moderate', 33);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (14, 'moderate', 28);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (15, 'moderate', 47);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (16, 'moderate', 50);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (17, 'moderate', 48);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (18, 'moderate', 60);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (19, 'moderate', 71);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (20, 'moderate', 42);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (21, 'high', 52);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (22, 'high', 64);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (23, 'high', 39);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (24, 'high', 54);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (25, 'high', 58);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (26, 'high', 53);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (27, 'high', 77);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (28, 'high', 56);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (29, 'high', 63);
INSERT INTO `TestScores` (`id`, `anxiety`, `score`) VALUES (30, 'high', 59);