title: How to make rows shuffle?
body: <p>There is a table with over 10+ rows, and now needed to shuffle all rows randomly and create a new table on it. any ideas ?</p>
  
  <p>Using <code>select * from table order by random()</code> seems slow.
  raw table is like,and the target column is separated into two parts:</p>
  
  <pre><code>+--------+------+--------+------+-----+--------+
  | cst_id | name | salary | fund | age | target |
  +--------+------+--------+------+-----+--------+
  |      1 | a    |    100 | Y    |  33 |      0 |
  |      2 | b    |    200 | Y    |  21 |      0 |
  |      3 | c    |    300 | Y    |  45 |      0 |
  |      4 | d    |    400 | N    |  26 |      0 |
  |      5 | e    |    500 | N    |  37 |      0 |
  |      6 | f    |    600 | Y    |  56 |      0 |
  |      7 | g    |    700 | Y    |  44 |      0 |
  |      8 | h    |    800 | N    |  22 |      1 |
  |      9 | i    |    900 | N    |  38 |      1 |
  |     10 | j    |   1000 | Y    |  61 |      1 |
  |     11 | k    |   1100 | N    |  51 |      1 |
  |     12 | l    |   1200 | N    |  21 |      1 |
  |     13 | m    |   1300 | Y    |  32 |      1 |
  |     14 | n    |   1400 | N    |  17 |      1 |
  +--------+------+--------+------+-----+--------+
  
  after:
  +--------+------+--------+------+-----+--------+
  | cst_id | name | salary | fund | age | target |
  +--------+------+--------+------+-----+--------+
  |      1 | a    |    100 | Y    |  33 |      0 |
  |      2 | b    |    200 | Y    |  21 |      0 |
  |      8 | h    |    800 | N    |  22 |      1 |
  |      9 | i    |    900 | N    |  38 |      1 |
  |      3 | c    |    300 | Y    |  45 |      0 |
  |     13 | m    |   1300 | Y    |  32 |      1 |
  |     14 | n    |   1400 | N    |  17 |      1 |
  |      5 | e    |    500 | N    |  37 |      0 |
  |      6 | f    |    600 | Y    |  56 |      0 |
  |      7 | g    |    700 | Y    |  44 |      0 |
  |     10 | j    |   1000 | Y    |  61 |      1 |
  |     11 | k    |   1100 | N    |  51 |      1 |
  |      4 | d    |    400 | N    |  26 |      0 |
  +--------+------+--------+------+-----+--------+
  </code></pre>