Boucle UPDATE, RAND

[Xenos]

Nope:

CREATE TEMPORARY TABLE `rand` (

  id INT,

  val DOUBLE

)

ENGINE=HEAP;



INSERT INTO `rand` (id, val) (SELECT id, RAND() FROM population);



UPDATE personnage p

INNER JOIN `rand` AS r ON r.id = p.id

SET nimporte_quel_champ = r.val;