title: Trying to update thousands of rows in a MySQL table from another table
body: <p>I'm trying update rows in a table (called "users") based on values found in another table (called "users_temp"). I have the query:</p>
  
  <pre><code>UPDATE users
  INNER JOIN users_temp on users_temp.email = users.email
  SET users.list_id = users_temp.list_id
  </code></pre>
  
  <p>Both tables have about 50k rows and this query basically just crashes MySQL. </p>
  
  <p>Can someone suggest a better way of doing this or tell me why MySQL is crashing?</p>
  
  <p>Thanks!</p>