title: MySQL - Copy data from one table into another in a random order
body: <p>I have created a new table identical to the original one and I would like to copy all the data to the new table in a random way.</p>
  
  <p>I use:</p>
  
  <pre><code>INSERT INTO `new_table` (`id`, `value`) 
      SELECT `id`, `value` FROM `original_table` ORDER BY RAND();
  </code></pre>
  
  <p>But as result I get new table in the same order as original one. For some reason RAND() is not working.</p>
  
  <p><strong>SOLVED</strong></p>
  
  <p>Sorry, that was my fault. Thank you for hinting comments, that helped. Since I have found threads asking similar quesiton I leave this post up. So I was trying to mix rows to make a dynamic content slider with those data a bit more interesting and I actually was needed to mix the IDs, so I just was supposed to take id columnt out of the query:</p>
  
  <pre><code>INSERT INTO `new_table` (`value`) 
      SELECT `value` FROM `original_table` ORDER BY RAND();
  </code></pre>