insert into mplaylog20170420 (mid,member,value) SELECT mid,member,value FROM `mplaylog20170420` WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `mplaylog20170420`))) ORDER BY id LIMIT 10000;