SELECT @i := 0; UPDATE table SET field = (select @i := @i + 1);