update tableName,
(select (@rank:=@rank+1) rank, projectId from(
select @rank:=0, projectId from tableName order by projectId) tmp) tmp2
set tableName.sort = tmp2.rank where tableName.projectId = tmp2.projectId
(select (@rank:=@rank+1) rank, projectId from(
select @rank:=0, projectId from tableName order by projectId) tmp) tmp2
set tableName.sort = tmp2.rank where tableName.projectId = tmp2.projectId
原来 修改可以 update table1,table2 set .... where ....可以这样写 - -