mysql - 试图获得单一的经验付款

Question

我有一个这样的查询

SELECT member_Id ,
       PERIOD_DIFF(
           DATE_FORMAT(now(),'%Y%m'), 
           DATE_FORMAT(memberToMship_StartDate,'%Y%m')
        )  + 
        (
           DAY(memberToMship_StartDate) < memberToMship_DueDay
        ) + 
        (
           DAY(now()) > memberToMship_DueDay
        ) - 1  
        AS ExpPayments 
FROM membertomships

它为所有成员(member)提供所有经验付款，这很好，我可以为单个成员(member)获得单一经验付款......

我需要添加任何连接或任何位置条件..

Answer 1

如果您知道 member_Id，您只需添加 WHERE 子句即可:

SELECT member_Id ,
       PERIOD_DIFF(
           DATE_FORMAT(now(),'%Y%m'), 
           DATE_FORMAT(memberToMship_StartDate,'%Y%m')
        )  + 
        (
           DAY(memberToMship_StartDate) < memberToMship_DueDay
        ) + 
        (
           DAY(now()) > memberToMship_DueDay
        ) - 1  
        AS ExpPayments 
FROM membertomships
WHERE member_Id = 213