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);
RedSky
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);