有个小细节今天差点没注意,需求是表里的两个字段求和,没考虑到有可能有字段为空,
本来的语句写成:
SELECT a_number + b_number AS stock FROM `materiel_storage`;
正确:
SELECT *,(IFNULL(a_number,0) + IFNULL(b_number,0)) AS stock FROM `materiel_storage`;//注意IFNULL判空
有个小细节今天差点没注意,需求是表里的两个字段求和,没考虑到有可能有字段为空,
本来的语句写成:
SELECT a_number + b_number AS stock FROM `materiel_storage`;
正确:
SELECT *,(IFNULL(a_number,0) + IFNULL(b_number,0)) AS stock FROM `materiel_storage`;//注意IFNULL判空