gpt4 book ai didi

mysql - 操作数应包含 1 列错误

转载 作者:太空宇宙 更新时间:2023-11-03 12:31:26 26 4
gpt4 key购买 nike

<分区>

我有以下问题

SELECT * 
FROM users
WHERE id NOT IN (
SELECT user_id
FROM `counter`
WHERE DATE_SUB( CURDATE( ) , INTERVAL 14 DAY ) <= created
)
AND id IN (
SELECT user_id
FROM coupon_used
)
AND id IN (
SELECT user_id
FROM accounts
)

我需要在 coupon_used 表中放置 where 子句,如果用户 id IN 优惠券使用表 where code ='xyz'。我喜欢这个

id IN (
SELECT user_id, code
FROM coupon_used WHERE code ='xyz'
)

但显示一个错误:

Operand should contain 1 Column.

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