table('buy_info') . $where2; goods_amount和good_user_rate是数据库的两个字段，请问正确的写法是怎样？"/> table('buy_info') . $where2; goods_amount和good_user_rate是数据库的两个字段，请问正确的写法是怎样？">
search

Home >Backend Development >PHP Tutorial >mysql计算两个字段的积的总和

mysql计算两个字段的积的总和

WBOY
WBOYOriginal
2016-06-06 20:24:283078browse

$sql1 = "SELECT SUM(goods_amount*goods_user_rate) FROM " . $GLOBALS['ecs']->table('buy_info') . $where2;

goods_amount和good_user_rate是数据库的两个字段，请问正确的写法是怎样？

回复内容：

$sql1 = "SELECT SUM(goods_amount*goods_user_rate) FROM " . $GLOBALS['ecs']->table('buy_info') . $where2;

goods_amount和good_user_rate是数据库的两个字段，请问正确的写法是怎样？

select sum(price * num) from table

SELECT SUM(ret) FROM(
SELECT goods_amount*goods_user_rate as ret FROM xxxx
);
我知道这样傻的写法是可以的。

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：curl爬取页面出现invalid host是什么原因？ Next article：不设置.domain.com子域之间能共享session吗？

Related articles

See more