sql杂记

//SELECT realName, IFNULL(picture,'' ) AS picture, gender FROM userInfo WHERE userId = '15089';如果picture为null(数据库默认值为null，给他赋值'')
//SELECT realName, picture, gender FROM userInfo WHERE userId = '15089';