UPDATE tableName AS A
INNER JOIN (
SELECT @rownum := @num+1 AS num, column_name,table_name.id
FROM (SELECT @rownum:=0) n,table_name
ORDER BY convert(table_name.`name` using gbk) ASC
) AS B ON A.id = B.id
SET A.`需要修改字段` = B.num WHERE A.id = B.id;