mysql - 为什么我不能在返回多个字段的请求中关联一个变量？

Question

下面的程序返回

Error Code: 1222: The used SELECT statements have a different number of columns

CREATE PROCEDURE `dev_getDashBoard`(cognito VARCHAR(100))
BEGIN
   DECLARE id_user,team_last INT;

   SELECT ct.hasInvoice,ct.currentCredits,ct.hasPremium,u.lastTeam INTO team_last  FROM configTeam ct
   INNER JOIN users u ON u.lastTeam = ct.team_id
   WHERE u.identityId = cognito COLLATE utf8_unicode_ci LIMIT 1

   CALL otherProcedure(team_last);
END

sql 总是返回一行。为什么mysql返回错误？

Answer 1

从 SELECT 中删除其他列:

SELECT u.lastTeam INTO team_last
FROM configTeam ct INNER JOIN
     users u
     ON u.lastTeam = ct.team_id
WHERE u.identityId = cognito COLLATE utf8_unicode_ci
LIMIT 1