mysql 随机获取数据并插入到数据库中

insert into result (user_id, activity_id, number) select user_id, activity_id from `activity_record`  order by rand() LIMIT 20;

select * into 表A form 表B where条件;