MYSQL根据一张表的行数生成对应的行号,而(SELECT(@rowNum := 0)) b的作用是每次执行都设置rowNum为0,
UPDATE t_if_sup_prod_detail prod
INNER JOIN (
SELECT a.*,(@rowNum:=@rowNum+1) rowNum FROM t_if_sup_prod_detail a,
(SELECT(@rowNum := 0)) b
) prodNew ON prod.sku = prodNew.sku
SET prod.indexNo = prodNew.rowNum;