SpellsBook

 +PHP
+ Adobe Flash 2 0 (0)
+ Arrays (4)
+ COM for Windows (2)
+ Image (2)
+ LDAP (3)
+ MySQL (11)
+ Basic MySQL Example
+ Database Information
+ Error Checking
+ Fetch Associative Array
+ Last Insert ID
+ Mysql PROD function
+ Number of Rows
+ SQL Dump to Database
+ Select Examples
+ Table and Field Information
+ Various Information
+ Regular Expressions (2)
+ String Manipulation (12)
+ Time and Date (6)
 +Snippet Options
+   Printer Friendly
 +Library Options
+   View Other Library
Adobe_Flash_3_0
C_Plus_Plus
Debian_Install
Del_me_Soon
HTML_and_CSS
JavaScript
Linux_Commands
PHP
 +General Options
+   Library Home
+   PHP-CSL Credits
+   PHP-CSL License
+   Resource Links
+   Log in
Syntax for: MySQL / Mysql PROD function

1:
exp(sum(log(n)))
 
Description for: MySQL / Mysql PROD function
  SUM and PROD functions

Sql has SUM(n) AVG(n) etc but no PROD(n) (this is bad)

Sneaky trick is to use exp(sum(log(n))) (This is good)


 
Powered by: PHP-CSL V0.9