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

Question

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

Answer 1

1. First thing first, set your mysql to accept multiple statement

   set mysql.createConnection({multipleStatements: true});

2. Do your query

   query_str = "CALL sp_whatever(?,?,?,@output); select @output"; con.query(query_str, [param1, param2, param3], function(err,rows){ if(err) throw err; console.log(rows); });

Output:

[OkPacket {
    fieldCount: 0,
    affectedRows: 0,
    insertId: 0,
    serverStatus: 10,
    warningCount: 0,
    message: '',
    protocol41: true,
    changedRows: 0 },
  [ RowDataPacket { '@output': -2 } ] ]