PHP Mysql指定列求和方式

求和Mysql一列数值用到

SELECT SUM(number) FROM `word`
//SUM(列名称)，求和number
SELECT SUM(number),COUNT(*) FROM `word`
//求和并统计数量

先看表结构，需要统计number总和

求number总和

求number总和，并COUNT显示统计数量

PHP

<?php
    $conn = mysqli_connect('localhost','root','');
	$db   = mysqli_select_db($conn,'XL');
	$sql  = 'SELECT SUM(number) as xlrun FROM word';
	$res  = mysqli_query($conn,$sql);
	$data = mysqli_fetch_assoc($res);
	echo "{$data['xlrun']}";
?>