快速在表中造数据

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;

转载于:https://www.cnblogs.com/starzhan/p/7079344.html