#更新顺序 SET @num=0; UPDATE casedetail SET status = (@num:= @num+1) WHERE caseId = 104 执行完后,将是从0开始,逐个递增的一列;