How do I bulk insert this array into the database?

1. How to insert the data from the values array into the database in bulk? The value obtained by
values is: values= [[1Jing 2pje 1pcr 00pr 418223] and the length of the array is uncertain, so the length here is 2. Thank you for guidance!

function insertData (data) {

    // console.log(data);
    // var events = [];
    var values=[];
    async.map(data,function(item,cb){
    _getNewSN({
        query:{category : "ProjectOID_" + item.ProjectOID},
        success:function(sn){
            var param=[parseInt(item.FunctionCode) ,
                        parseInt(item.StartRegister) ,  
                        parseInt(item.Length) , 
                        item.Description , 
                        item.ProjectHardwareOID , 
                        sn.SN];
            cb(null,param)
        },
        error : sender.error
    });
    },function(err,values){
        console.log(values)
        var sql = "insert into " + 
                    "plcModbusTCPDB(FunctionCode,StartRegister," + 
                    "Length,Description,ProjectHardwareOID," + 
                    "DataID) values (?,?,?,?,?,?)";
        yjDBService.exec({
            sql:sql,
            parameters : values,
            success : sender.success,
            error : sender.error
        });
    })-sharp-sharp-sharp

the environmental background of the problems and what methods you have tried

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

Sql node.js javascript
Mar.31,2022

1, the values array is spliced into batch insert strings, and then the sql is concatenated directly. The code is as follows:
2. It is recommended to use sequelizejs . It is more safe and convenient to operate the database. 

const values = [[1, 2, 1, "00", 418, 223], [1, 3, 1, "00", 418, 224]]

var str = '';
const len = values.length;
for (let index = 0; index < len; indexPP) {
    const element = values[index].toString();
    str += '(' + element + ')';
    if (index != len - 1) str += ',';
}

console.log(str) // (1,2,1,00,418,223),(1,3,1,00,418,224)
const sql = "insert into " +
    "plcModbusTCPDB(FunctionCode,StartRegister," +
    "Length,Description,ProjectHardwareOID," +
    "DataID) values " + str;

Previous: About Mui.openWindow turning in circles and not jumping

Next: Refresh the page in vue, only refresh the main part, but not the navigation bar.

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e43d7e-65081.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e43d7e-65081.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?