title: How do I do a bulk update in mySQL using node.js
body: <p>i want to update data in bulk i have over 50 rows to be updated in an array of objects in node JS. something like
  <a href="https://github.com/felixge/node-mysql" rel="nofollow noreferrer">https://github.com/felixge/node-mysql</a>
  and <a href="https://stackoverflow.com/questions/8899802/how-do-i-do-a-bulk-insert-in-mysql-using-node-js/14259347#14259347">How do I do a bulk insert in mySQL using node.js</a></p>
  
  <pre><code>var updateData=[ 
      {a: '15',b: 1,c: '24',d: 9,e: 1,f: 0,g: 0,h: 5850,i: 78 },
      {a: '12',b: 1,c: '21',d: 9,e: 1,f: 0,g: 0,h: 55,i: 78 },
      {a: '13',b: 1,c: '34',d: 9,e: 1,f: 0,g: 0,h: 58,i: 78 },
      {a: '14',b: 1,c: '45',d: 9,e: 1,f: 0,g: 0,h: 585,i:78 },
      {a: '16',b: 1,c: '49',d: 9,e: 1,f: 0,g: 0,h: 85,i: 78 } 
  ]
  my query is : update table set a= updateData.a ,b= updateData.b ,c = updateData.c , d==updateData.d ,e=updateData.e,f=updateData.f where e=updateData.e
  </code></pre>