PHP and MySQL Programming/Common Functions and Operators

From Wikibooks, open books for an open world
Jump to navigation Jump to search

COUNT

[edit | edit source]
mysql_query(" SELECT COUNT(*|`field_name`) FROM `table_name` ");

SUM

[edit | edit source]
mysql> SELECT SUM(`field_name`) FROM `table_name`;


Basic Queries PHP and MySQL Programming
Common Functions and Operators 		XML and PHP
Retrieved from "https://en.wikibooks.org/w/index.php?title=PHP_and_MySQL_Programming/Common_Functions_and_Operators&oldid=3644587"