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

它向所有成员支付所有费用,这些款项是罚款的,可以一次性向单一成员支付。

是否需要加入或加入任何条件。

Answer 1

where  member_Id = {enter the id}

Answer 2

If you know the member_Id you could just add a WHERE clause :

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

友情链接