X3

RedSky

导航

nodejs中写sql需要用in时的写法

let data = [1,2,3];
let sql = `selec * from table1 where type in (${data.map(m=>'?').join(',')})`;
let params = [...data];
await conn.execute(sql, params);

 

posted on 2025-08-01 16:00  HotSky  阅读(3)  评论(0)    收藏  举报