Archive:PHP and MySQL Programming/Common Functions and Operators

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]]