常用情况,以下是计算库存,如果库存或者锁定库存为空,则给默认值为0
SELECT
(IFNULL(t_inventory.pro_number,0)-IFNULL(t_inventory.locked_number,0)) AS content_number
FROM
t_inventory
转载于:https://www.cnblogs.com/zhangjian816/p/9753369.html
常用情况,以下是计算库存,如果库存或者锁定库存为空,则给默认值为0
SELECT
(IFNULL(t_inventory.pro_number,0)-IFNULL(t_inventory.locked_number,0)) AS content_number
FROM
t_inventory
转载于:https://www.cnblogs.com/zhangjian816/p/9753369.html