how to pass in and out parameters to a mysql stored procedure and return the stored procedure result in the nodejs code

Question

how to pass in and out parameters to a mysql stored procedure and return the stored procedure result in the nodejs code

connection.query("call vts_active_tagid('"+RFIDNumber+"','"+Latitude+"','"+Longitude+"','"+datetime+"','"+imeno+"',@passengers,@trip)");

this stored procedure gives one output which contains firstname,phone number and passengerid,how to get those values in the nodejs code

mysql
node.js
stored-procedures

Answer 1

a sample for you

dbConnection.getConnection(function(err, connection){
        var edituserSQL =  "CALL spEditTheme(?,?,?,?)";
        var resultt;
        connection.query(edituserSQL, [ object.selfid,object.theme_background,object.theme_foreground,dateTimeNow ], function(ERROR,RESULT) {
                if (ERROR) {
                    cb(ERROR, null);
                } else {
                    console.log("exEditUserTheme result");
                    console.log(RESULT);
                    var account = RESULT[0][0].result;
                    cb(null, account);
                }
            });

            connection.release();
    });