nodejs,mysql语句in的写法

exports.findTest = async()=>{
const ids = ['b3bc6e3dbb2a420aa8d569d70283e4ed', '6fa0671fd75d418398b5ab4a35bfe21d']
const sql = `select id,pay_type from pet_register_info where id in (?)`;
const result = await conn.query(sql, [ids]);
return result[0];
}
posted @ 2019-09-19 18:28  江山一族  阅读(1982)  评论(0编辑  收藏  举报