How to update multiple columns in mysql using nodejs
<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>