Mariadb syntax error in multipleStatements

Question

When I try to execute multipleStatements in Mariadb like this

db.Connection.query("CALL tep_procedure_out(?,@out_value);Select @out_value",["rahul"],

I installed {multipleStatements: true} in my connection, although I am getting an error.

{Error: you have an error in the SQL syntax; check the manual that matches the MariaDB server version for the correct syntax to use next to "Select @out_value" on line 1: 1064}

Answer 1

By default, sending multiple statements is disabled (not only in node.js, but also in most other connectors) for security reasons.

, :

var conn = mysql.createConnection({multipleStatements: true});