mysql sum null 转为0

1、select isnull(sum(count),0) coinNum from table

2、select coalesce(sum(count),0) coinNum from table



© 2016-2024 阿尔佛 aerfo.com | 豫ICP备17044542号 | 豫公网安备 41010602000172