Archive:PHP and MySQL Programming/Common Functions and Operators: Difference between revisions
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 |
wikademia>The Kid No edit summary |
||
| Line 6: | Line 6: | ||
mysql> SELECT SUM(`field_name`) FROM `table_name`; | mysql> SELECT SUM(`field_name`) FROM `table_name`; | ||
[[../Basic Queries/|Previous: Basic Queries]] | [[../|TOC]] | [[../XML and PHP/|Next: XML and PHP]] | |||
[[Category:PHP]] | [[Category:PHP]] | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
Revision as of 11:29, 2 April 2007
COUNT
mysql> SELECT COUNT(*|`field_name`) FROM `table_name`;
SUM
mysql> SELECT SUM(`field_name`) FROM `table_name`;
[[../Basic Queries/|Previous: Basic Queries]] | [[../|TOC]] | [[../XML and PHP/|Next: XML and PHP]]