mysql 批量刷新 -- 顺序刷新

UPDATE rushbuy_product r
JOIN (
	SELECT
		id,
		sort
	FROM
		`rushbuy_product`
	WHERE
		`status` = 1
	AND valid = 1
	ORDER BY
		ifnull(sort, 8888),
		publish_time DESC
) a ON r.id = a.id,
 (SELECT @number := 0) b
SET r.sort =@number :=@number + 1