数据库用的mysql select IFNULL(max(p_usable_sku_num),0) as p_usable_sku_num from promotion_temp_stock where sku_code=#{id} </select>
之前用ifnull(p_usable_sku_num,0) 还是报错
后来改成上面的 运行成功
数据库用的mysql select IFNULL(max(p_usable_sku_num),0) as p_usable_sku_num from promotion_temp_stock where sku_code=#{id} </select>
之前用ifnull(p_usable_sku_num,0) 还是报错
后来改成上面的 运行成功