注册

nodejs插入一条语句,怎么获取自增主键的id

郭峰 2021/10/11 1324 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
现在我用nodejs插入一条语句,结果返回值是

t { rowsAffected: 1 }

我想知道如何返回这个自增的id

部分代码

let bind = [ { val: '111' }, { val: 0 }, { val: '2021-10-11 14:01:03' }, { val: '2021-10-11 14:01:03' }, { val: 1 }, { val: null }, { val: 1 }, { val: 'icon' }, { val: 0 } ] let sql = `INSERT INTO "map-category" ("label","parent_id","created_at","updated_at","created_user_id","updated_user_id","status","icon","order_index") VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9)`; // let sql = `select * from "map-category"`; let result = await conn.execute(sql, bind);
回答 0
暂无回答
扫一扫
联系客服