MySQL SUM(IF(…)) 根据extcredits1 > 0条件求总数 SELECT SUM(IF(extcredits1 > 0, extcredits1, 0)) AS plus_e1, SUM(IF(extcredits1 < 0, extcredits1, 0)) AS minus_e1 FROM pre_common_credit_log