我这里有代码连接两个表。但是我不想从帐户数据库中获取password元素。我怎么能这样做?

"SELECT f.*, a.*
   FROM Following as f
   JOIN Accounts as a on f.followingUserID = a.id
  WHERE `followingUserID` = '$acID'

最佳答案

对于“除…以外的所有列”,没有SQL约定--要么全部,要么手动定义列表:

SELECT f.*,
       a.col1, a.col2,
       a.`col name using spaces not good`
  FROM FOLLOWING as f
  JOIN ACCOUNTS as a on f.followingUserID = a.id
 WHERE f.followingUserID = '$acID'

关于php - 选择除JOIN MySQL中的元素以外的所有元素,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/6286861/

10-15 03:25
查看更多