title: How to update multiple columns using array of datas with a prepared statement?
body: <p>I have 2 arrays :</p>
  
  <pre><code>columns = ['column1', 'column2'];
  data = ['data1', 'data2'];
  </code></pre>
  
  <p>I'd like to update the table using a prepared query:</p>
  
  <pre><code>conn.query('UPDATE table SET ?? = ? WHERE id = ?', [columns, data, id], 
  function(err, info){
  </code></pre>
  
  <p>Excepted sql query :</p>
  
  <pre><code>UPDATE table SET column1 = 'data1', column2 = 'data2' WHERE id = 10
  </code></pre>
  
  <p>But I get something that looks like : </p>
  
  <p><code>UPDATE table SET 'column1', 'column2' = 'data1', 'data2' WHERE id = 10</code></p>
  
  <p>This feature works well for select or insert but it seems not working for update queries. Any thoughts on how I can get this work ?</p>