How to add variable to MYSQL + express query?

Question

Node.js

Good afternoon!
Tell me please.
How to add a variable to a MYSQL query

var valProgrammNumber =          req.body.programmNumber;
var valFullName =                        req.body.fullName;
var valCompany =                         req.body.company;

connection.query('INSERT INTO umodoc (programmNumber, fullName, company) 
                             VALUES (valProgrammNumber, valFullName, valCompany)',
function(err, rows, fields) {
  console.log(err);
});
connection.end();
});

doesn't work like that.
Thanks in advance!

Answer 1

connection.query('INSERT INTO umodoc (programmNumber, fullName, company) VALUES (?, ?, ?)', [valProgrammNumber, valFullName, valCompany]...