Archive:PHP and MySQL Programming/Common Functions and Operators
Appearance
COUNT
mysql> SELECT COUNT(*|`field_name`) FROM `table_name`;
SUM
mysql> SELECT SUM(`field_name`) FROM `table_name`;
mysql> SELECT COUNT(*|`field_name`) FROM `table_name`;
mysql> SELECT SUM(`field_name`) FROM `table_name`;