How to make a query in sql?

Question

MySQL

Here is the given code:

connection.query(
    'INSERT INTO `message` (email, name, message) VALUES (":email", ":name", ":message")',
    { email: req.body.email, name: req.body.name, message: req.body.message },
    (err, result) => {
      console.log(req.body);
      console.log(req.body.name);
      console.log(result);
      res.send(result);
    }
  );

why can't I send changes, or how to compose them. Thanks for the help!!!

Answer 1

It is possible to transfer through `$(var)`.