mysql 查询为空处置

分类: IT文章 • 2024-01-16 08:16:13

mysql 查询为空处理
private static final String ENQUIRYSHOPPINGCART_INFO_SQL = "select IFNULL((select e.id from ap_products.enquiryshoppingcart e where e.enquiry_order_id=?),0)";

通过id查询为空时，返回0