Question

ecshop 中 [errno] => 1582 错误是什么意思

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT rank_id, IFNULL(mp.user_price, r.discount * 1,298 / 100) AS price, r.rank_name, r.discount FROM `buywater`.`w_user_rank` AS r LEFT JOIN `buywater`.`w_member_price` AS mp ON mp.goods_id = '456' AND mp.user_rank = r.rank_id WHERE r.show_price = 1 OR r.rank_id = '0' ) [2] => Array ( [error] => Incorrect parameter count in the call to native function 'IFNULL' ) [3] => Array ( [errno] => 1582 ) )

Answer 1

MYSQL 的IFNULL函数只有两个参数：

IFNULL(expr1,expr2)

你用了三个参数，所以报错：

 IFNULL(mp.user_price, r.discount * 1,298 / 100) AS price

追问

怎么把价格中间的点去掉？