title: How to update multiple columns in mysql using nodejs
body: <p>How to update the multiple columns in MySQL using node.js:</p>
  
  <pre><code>var query = 'UPDATE employee SET profile_name = ? WHERE id = ?';
  connection.query(query,[req.name,req.id] function (error, result, rows, fields) {
  </code></pre>
  
  <p>but I have to update <code>profile_name</code>, <code>phone,email</code>, <code>country</code>, <code>state</code>, <code>address</code> at once.<br>
  How can I do that, can anyone suggest.</p>