在JOIN MySQL中选择除on元素以外的所有元素 - Select all but on element in JOIN MySQL

Select all but on element in JOIN MySQL

本文关键字：元素 on MySQL JOIN 选择 | 更新日期: 2023-09-27

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

"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'

命名列，而不是检索所有列。

代替a.*，：

a.ColumnName1、a.ColumnName2等…

如果您不想选择密码元素，则需要更改a.*以单独选择每一列，即

SELECT f.*, a.account_id, a.name 
FROM following as f 
JOIN accounts as a on f.followingUserId = a.id 
WHERE followingUserID = '$acID'