gpt4 book ai didi

mysql - 错误 #1241 - 在 Mysql 中操作数应包含 1 列

转载 作者:可可西里 更新时间:2023-11-01 07:46:11 26 4
gpt4 key购买 nike

<分区>

我只是尝试以下查询:

SELECT *, 
(
SELECT count(*)
FROM users
where users.email=calls.email
) as ureg,
(
SELECT sum(qty)
FROM product
where product.owner in
(SELECT *
from users
where users.email=calls.email)
) as pop
FROM calls
order by calls.data desc
LIMIT 0,20

但我收到以下错误:

#1241 - Operand should contain 1 column(s)

我应该如何修复我的查询?

编辑:通过改变SELECT * from users where users.email=calls.emailSELECT id from users where users.email=calls.email

之所以有效,是因为查询在用户中存在的一堆 id 中搜索 product.owner

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com