Archive:PHP and MySQL Programming/Common Functions and Operators: Difference between revisions
wikademia>Ralfe No edit summary |
wikademia>Jguk mNo edit summary |
||
| Line 8: | Line 8: | ||
mysql> SELECT SUM(`field_name`) FROM `table_name`; | mysql> SELECT SUM(`field_name`) FROM `table_name`; | ||
[[Category:PHP]] | |||
[[Category:MySQL]] | |||
Revision as of 16:11, 15 July 2006
COUNT
mysql> SELECT COUNT(*|`field_name`) FROM `table_name`;
SUM
mysql> SELECT SUM(`field_name`) FROM `table_name`;