For loop not generating sequice in nodejs

I am trying to insert the query in nodeJs where the transactionCode will automatically generate. but in my case when I insert in all the 5 insert query inserting with the same transactionCode as ABC123 but it should be inserted with ABC123, ABC124, ABC125, ABC126, AB127
an even I am calling this generate function in the loop then why it not working and generating one by one and inserts.

please help how me fix this issue and make my code correct.

for (let i = 0; i < 5; i++) {
    var stmt, transactionCode;

    stmt = await con.query("SELECT `token` FROM `table1` ORDER BY `ID` DESC LIMIT 1", {
        type: con.QueryTypes.SELECT,
   // this function will return auto number with +1 to with previous number, suppose my previous number is ABC123 then my next number will ABC124
    if (stmt.length > 0) { (item) => {
            transactionCode = item.token;
            let strings = transactionCode.replace(/[0-9]/g, "");
            let digits = (parseInt(transactionCode.replace(/[^0-9]/g, "")) + 1).toString();
            if (digits.length < 2) digits = ("000" + digits).substr(-3);
            transactionCode = strings + digits;
    } else {
        transactionCode = "ABC123";
        let stmt1;
        stmt1 = await con.query("INSERT INTO `table2` (`col1`,`col2`) VALUES(:token, :name)", {
            replacements: {
                token: transactionCode,
            type: con.QueryTypes.INSERT,
            transaction: transaction,


return res.json({ code: 200, message: "Generated", status: "success" });


Why not use your debugger to step through the code? For example the VSCODE editor implements a debugger fairly simply.

Debugging is an important thing for Node.Js development.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.