Archive:PHP and MySQL Programming/Common Functions and Operators: Difference between revisions
wikademia>Jguk mNo edit summary |
wikademia>The Kid New page: == COUNT == mysql> SELECT COUNT(*|`field_name`) FROM `table_name`; == SUM == mysql> SELECT SUM(`field_name`) FROM `table_name`; Category:PHP Category:MySQL |
||
| Line 1: | Line 1: | ||
== COUNT == | == COUNT == | ||
Revision as of 10:45, 2 April 2007
COUNT
mysql> SELECT COUNT(*|`field_name`) FROM `table_name`;
SUM
mysql> SELECT SUM(`field_name`) FROM `table_name`;