2 replies to this topic

[lol33d]

hi guys

this is my table:

CREATE TABLE IF NOT EXISTS `multiplying` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `price` float NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;


--

-- Dumping data for table `multiplying`

--


INSERT INTO `multiplying` (`id`, `price`) VALUES

(1, 250),

(2, 5),

(3, 3),

(4, 1),

(5, 4.5);

so my numbers is: 250, 5, 3, 1, 4.5

for sum all numbers: 250 + 5 + 3 + 1 + 4.5
i use this query:

SELECT SUM(`price`) FROM `multiplying`

how to Multiplying all numbers?

Multiplying: 250 * 5 * 3 * 1 * 4.5



thank you so much

[Gerg? Magyar]

[COLOR="#0000FF"]SELECT[/COLOR] [COLOR="#0000FF"]EXP[/COLOR]([COLOR="#0000FF"]SUM[/COLOR]([COLOR="#0000FF"]LOG[/COLOR](`price`))) [COLOR="#0000FF"]FROM[/COLOR] `multiplying`

[lol33d]

nice, thank you