sql 的where in子句应该用小括号吧 #2
Description
from：
{
"Product:p":{
"@column":"id,code,name,price",
"brand_id!{}": [1,4,5]
}
}
to：
SELECT p.id, p.code, p.name, p.price
FROM Product p
WHERE (p.brand_id NOT IN [1, 4, 5])
{{ message }}
from：
{
"Product:p":{
"@column":"id,code,name,price",
"brand_id!{}": [1,4,5]
}
}
to：
SELECT p.id, p.code, p.name, p.price
FROM Product p
WHERE (p.brand_id NOT IN [1, 4, 5])