mysql 值为空，就返回0

oracle中：select nvl(字段名,0) from 表名;
sqlserver中：select isnull(字段名,0) from 表名;
mysql中：select ifnull(字段名,0) from 表名;
mysql举例：

select a.stu_id,a.course_id,(IFNULL(a.score,0)+IFNULL(b.score,0))  score
 	from a left join b 
	on a.stu_id = b.stu_id and a.course_id = b.course_id