title: How to replace data in one column in a table with data from a column in another table?
body: <p>I have a table called users that has first_name and last_name columns and I want to shuffle the values in these columns so the names are no longer identifiable as real people.</p>
  <p>I thought one way to achieve this would be to create a shuffle table, which takes the value from each column ordered randomly and then sets those values back into the users table, but I can't seem to get that to work.</p>
  <p>The code I've tried is:</p>
  <pre><code>CREATE TABLE shuffle SELECT first_name FROM users ORDER BY RAND();
  INSERT INTO users (first_name) SELECT first_name FROM shuffle;
  </code></pre>
  <p>I don't get any error messages when I run this, but it doesn't do what I'm wanting. Is this the right approach? What am I doing wrong?</p>