出现NULL的情况:
- 零条数据时
- 所有的这一行都为null
解决:
ifnull(sum(ifnull(table_a.area,0))
例子:
SELECT count(table_a.id) 总数, ifnull(sum(ifnull(table_a.area,0.00)),0.00) 总面积
FROM table_a
出现NULL的情况:
解决:
ifnull(sum(ifnull(table_a.area,0))
例子:
SELECT count(table_a.id) 总数, ifnull(sum(ifnull(table_a.area,0.00)),0.00) 总面积
FROM table_a