CREATE TABLE `item_test` ( `vendor_id` int(11) unsigned NOT NULL default '0', `price` decimal(8,2) NOT NULL default '0.00', `qty` mediumint(6) unsigned NOT NULL default '0' ) TYPE=MyISAM; INSERT INTO `item_test` VALUES (1, '21.60', 1), (1, '21.60', 2), (1, '30.00', 1), (2, '35.00', 2);