CREATE TABLE IF NOT EXISTS `student4` ( `id` int(2) NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `class` varchar(10) NOT NULL DEFAULT '', `social` int(3) NOT NULL DEFAULT '0', `science` int(3) NOT NULL, `math` int(3) NOT NULL, `percentage` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `student4` -- INSERT INTO `student4` (`id`, `name`, `class`, `social`, `science`, `math`, `percentage`) VALUES (2, 'Max Ruin', 'Three', 85, 56, 85, 79.2982), (3, 'Arnold', 'Three', 55, 40, 75, 59.6491), (4, 'Krish Star', 'Four', 60, 50, 70, 63.1579), (5, 'John Mike', 'Four', 60, 80, 90, 80.7018), (6, 'Alex John', 'Four', 55, 90, 80, 78.9474), (7, 'My John Rob', 'Fifth', 78, 60, 70, 72.9825), (8, 'Asruid', 'Five', 85, 80, 90, 89.4737), (9, 'Tes Qry', 'Six', 78, 60, 70, 72.9825), (10, 'Big John', 'Four', 55, 40, 55, 52.6316);