UPDATE cy_order AS a
INNER JOIN (
SELECT
@group_row := CASE
WHEN @parent_code = a.user_id THEN
@group_row + 1
ELSE
1
END AS groupRow,
@parent_code := a.user_id AS parent_code,
user_id,
create_time,
oid
FROM
cy_order a,
(
SELECT
@group_row := 1,
@parent_code := ''
) AS b
ORDER BY
a.user_id
) AS b ON a.oid = b.oid
SET a.order_count = b.groupRow; 最佳答案
