Strawberryshrub Eve 晨曦

让 GroupId 自动递增,然后再创建一列 RandomGroupId 在里面 groupInformation ,然后粘贴查询:

INSERT INTO groupInformation(RandomGroupId,RegistrationId) 
SELECT randomRegistrationId,RegistrationId 
FROM (Select *,RAND() AS randomRegistrationId 
      FROM userInformation ORDER BY randomRegistrationId LIMIT ".$GroupSize."
      ) AS j