批量 mysql 語句如下

INSERT INTO
[表名] ([列名],[列名])
VALUES
([列值],[列值])),
([列值],[列值])),
([列值],[列值]));

async addRows(list) {
    // list 結(jié)構(gòu) [[id,title,href],[id,title,href]]
    const result = await this.app.mysql.query("INSERT INTO spider_hotlist (id,title,href) values ?", [list]);
    return result;
  }

也就是我調(diào)用這個方法傳遞參數(shù)示例如下：

const res = await ctx.service.spiderHotlist.addRows([
      [2,'test','test'],
      [3,'test','test']
    ]);