将三百万的数据平均分给1000个用户

-- 创建一个临时表存储员工ID和应分配数据数量
CREATE TEMPORARY TABLE temp_employee_data (
  employee_id bigint(20) NOT NULL,
  data_count int(11) NOT NULL,
  INDEX idx_employee_id (employee_id)
);

-- 计算每个员工应分配的数据数量并插入临时表
INSERT INTO temp_employee_data (employee_id, data_count)
SELECT 
  id,
  CEIL((SELECT COUNT(*) FROM shop_product_flow_order1 WHERE tenant_id = '171299305372910000') / 1008) -- 假设每个员工应分配 3000 条数据
FROM rxk_admin.sys_user
WHERE tenant_id = '171299305372910000'; -- 根据需要更新的租户ID筛选

-- 更新 shop_product_flow_order1 表的员工归属人ID字段
-- 使用子查询获取需要更新的数据
UPDATE shop_product_flow_order1 t
JOIN (
  SELECT id, (ROW_NUMBER() OVER () - 1) DIV 3008 + 1 AS employee_group
  FROM shop_product_flow_order1
  WHERE tenant_id = '171299305372910000'
) AS ranked ON t.id = ranked.id
JOIN (
  SELECT employee_id, data_count, ROW_NUMBER() OVER () AS row_num
  FROM temp_employee_data
) AS e ON ranked.employee_group = e.row_num
SET t.follow_user_id = e.employee_id
WHERE t.tenant_id = '171299305372910000';

-- 删除临时表
DROP TEMPORARY TABLE temp_employee_data;