insert into test (除ID外的所有字段) SELECT 除ID外的所有字段 FROm `test`  WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `test`))) ORDER BY id LIMIT 1000000