SET @mycnt = 0; UPDATE xxxxxSET RowNum=(@mycnt := @mycnt + 1) 转载于:https://www.cnblogs.com/allenjsl/p/5670134.html