CREATE TABLE student ( id int(2) NOT NULL auto_increment, name varchar(50) NOT NULL default '', class varchar(10) NOT NULL default '', mark int(3) NOT NULL default '0', sex varchar(6) NOT NULL default 'male', UNIQUE KEY id (id) ) TYPE=MyISAM; 



INSERT INTO `student` VALUES (1, 'John Deo', 'Four', 75, 'female');
INSERT INTO `student` VALUES (2, 'Max Ruin', 'Three', 85, 'male');
INSERT INTO `student` VALUES (3, 'Arnold', 'Three', 55, 'male');
INSERT INTO `student` VALUES (4, 'Krish Star', 'Four', 60, 'female');
INSERT INTO `student` VALUES (5, 'John Mike', 'Four', 60, 'female');
INSERT INTO `student` VALUES (6, 'Alex John', 'Four', 55, 'male');
INSERT INTO `student` VALUES (7, 'My John Rob', 'Fifth', 78, 'male');
INSERT INTO `student` VALUES (8, 'Asruid', 'Five', 85, 'male');
INSERT INTO `student` VALUES (9, 'Tes Qry', 'Six', 78, 'male');
INSERT INTO `student` VALUES (10, 'Big John', 'Four', 55, 'female');
INSERT INTO `student` VALUES (11, 'Ronald', 'Six', 89, 'female');
INSERT INTO `student` VALUES (12, 'Recky', 'Six', 94, 'female');
INSERT INTO `student` VALUES (13, 'Kty', 'Seven', 88, 'female');
INSERT INTO `student` VALUES (14, 'Bigy', 'Seven', 88, 'female');
INSERT INTO `student` VALUES (15, 'Tade Row', 'Four', 88, 'male');
INSERT INTO `student` VALUES (16, 'Gimmy', 'Four', 88, 'male');
INSERT INTO `student` VALUES (17, 'Tumyu', 'Six', 54, 'male');
INSERT INTO `student` VALUES (18, 'Honny', 'Five', 75, 'male');
INSERT INTO `student` VALUES (19, 'Tinny', 'Nine', 18, 'male');
INSERT INTO `student` VALUES (20, 'Jackly', 'Nine', 65, 'female');
INSERT INTO `student` VALUES (21, 'Babby John', 'Four', 69, 'female');
INSERT INTO `student` VALUES (22, 'Reggid', 'Seven', 55, 'female');
INSERT INTO `student` VALUES (23, 'Herod', 'Eight', 79, 'male');
INSERT INTO `student` VALUES (24, 'Tiddy Now', 'Seven', 78, 'male');
INSERT INTO `student` VALUES (25, 'Giff Tow', 'Seven', 88, 'male');
INSERT INTO `student` VALUES (26, 'Crelea', 'Seven', 79, 'male');
INSERT INTO `student` VALUES (27, 'Big Nose', 'Three', 81, 'female');
INSERT INTO `student` VALUES (28, 'Rojj Base', 'Seven', 86, 'female');
INSERT INTO `student` VALUES (29, 'Tess Played', 'Seven', 55, 'male');
INSERT INTO `student` VALUES (30, 'Reppy Red', 'Six', 79, 'female');
INSERT INTO `student` VALUES (31, 'Marry Toeey', 'Four', 88, 'male');
INSERT INTO `student` VALUES (32, 'Binn Rott', 'Seven', 90, 'female');
INSERT INTO `student` VALUES (33, 'Kenn Rein', 'Six', 96, 'female');
INSERT INTO `student` VALUES (34, 'Gain Toe', 'Seven', 69, 'male');
INSERT INTO `student` VALUES (35, 'Rows Noump', 'Six', 88, 'female');