Archive:PHP and MySQL Programming/Common Functions and Operators: Difference between revisions
wikademia>Darklama m Programming:PHP and MySQL/Common Functions and Operators moved to PHP and MySQL Programming/Common Functions and Operators: using modern naming convention |
wikademia>Darklama m recat sort |
||
| Line 9: | Line 9: | ||
[[../Basic Queries/|Previous: Basic Queries]] | [[../|TOC]] | [[../XML and PHP/|Next: XML and PHP]] | [[../Basic Queries/|Previous: Basic Queries]] | [[../|TOC]] | [[../XML and PHP/|Next: XML and PHP]] | ||
[[Category:PHP | [[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]] | ||
Revision as of 14:24, 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]]