title: How to update multiple records in a table?
body: <p>I need to update the column <code>B</code> in a table, which has a column <code>A</code> as the primary key, with the a different value for each value in column <code>A</code>. There are about 50,000 rows to be updated in the table, which makes it impossible to do this manually. Is there any other way to update it? </p>
  
  <p>Of all the records in the table, I want to update just 50000. For each record among these 50,000, the value to be updated is different. How can I update the table without having to write 50,000 update queries?</p>
  
  <pre><code>Column A.   Column B
    One.             1
    Two              2
    Three            3
  </code></pre>
  
  <p>I want to update <code>one=4</code>, <code>two=5</code> and so on for about 50,000 rows. </p>
  
  <p>Thanks in advance guys! </p>