update data_supplier_access dsa inner join (SELECT @row:=0) as t on 1=1 set dsa.code = ( @row:= @row+ 1 ) where id > 1;