select * from a inner join (select * as id from (1,2)) as b on a.id = b.id
...全文
643打赏收藏
mysql 语法
在 mysql里 是否支持 select * from (1,2) 这样的语句 把一个 常量数组 转成 一个临时表处理 例如 select * from a where id in (1,2) 改成 select * from a inner join (select * as id from (1,2)) as b on a.id = b.id