mysql - Node.js 使用异步方式运行 MySQL 查询

Question

如何在异步查询中运行循环查询？

let someRows1, someRows2, someRows3, otherRows1;

    .then( rows => {
        someRows3 = rows;
        someRows3.forEach(function (element) {
            database.query( 'UPDATE  `orders` SET `amount` = "' + element.value + '" WHERE `id` = "' + element.id + '"' );
        });
    })
    .then( () => {
        // do something with someRows and otherRows
    });

Answer 1

你可以使用等待... of link to documentation