在MySql中,您可以
SUM()在条件上使用该函数,因为错误条件将等于
0,而真正条件将等于
1:
SELECt SUM(userID_follower = $myID) AS followerCount, SUM(userID_following = $myID) AS followingCountFROM t1WHERe userID_follower = $myID OR userID_following = $myID

在MySql中,您可以
SUM()在条件上使用该函数,因为错误条件将等于
0,而真正条件将等于
1:
SELECt SUM(userID_follower = $myID) AS followerCount, SUM(userID_following = $myID) AS followingCountFROM t1WHERe userID_follower = $myID OR userID_following = $myID