php - 在 JOIN MySQL 中选择除元素之外的所有元素

Question

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

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

Answer 1

对于“除...之外的所有列”没有 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'