快速在表中造数据

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;

posted @ 2017-06-26 10:19  詹老师  阅读(221)  评论(0编辑  收藏  举报