MySQL判断数据是否为空

IFNULL(expr1,expr2)函数，这个函数只能判断是否为空

SELECT
CONCAT(first_name,',',last_name,',',job_id,IFNULL(commission_pct,0)) AS out_put
FROM
employees;