mysql 将null转代为零

2012-07-19

mysql 将null转代为0引用select sum(score),IFNULL(sum(score),0) as sumcore from t_user_course as tuc

mysql 将null转代为0
引用select sum(score),IFNULL(sum(score),0) as sumcore from t_user_course as tuc where coursestatus=4 and userid=25