我这里有代码连接两个表。但是我不想从帐户数据库中获取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/