问题描述
我有2种软件(均为Java):一种使用MySSQL，另一种使用H2数据库.我的问题是在MySQL中，我有以下查询:
I have 2 kinds of software (both Java): One with MySSQL and the other with H2 database. My problem is that in MySQL I have this query:
Select * from X where (1,2,3) in (select 4,5,6 from Y)
但是在H2中，抛出此错误:
But in H2 throw me this error:
我基本上理解了这是什么意思，但是我需要从X中选择Y中的所有值，并且我读到这是最有效的方法.另一种方法是将Y中的所有值分配给Java对象，然后将其放入X中，但我知道这不是最佳"的方法
I understand basically what this mean but I need to select all values from X that are in Y and I read that this is the most efficient way. The other way could be asign all the values from Y to a Java Object and then put them in to X but I know that this is not the "best" way to do it
推荐答案
尝试将查询修改为具有单个值
Try to modify the query to have single values
Select * from X where CONCAT(1,2,3) in (select CONCAT(4,5,6) from Y)
因此，您有一个3列值都连接在一起的字段，而不是3列
So instead of 3 columns you have one where all the 3 column values are joined
这篇关于H2中的where()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！