In the commande below:
SET @var=1; UPDATE characters SET tmp = IF(isRadical=1, @var=1, @var:=@var+1);
I'm expecting @var
and tmp
column to be reset to 1
when the column isRadical=1
for a row, and incrementing otherwise. But what I get instead is that tmp
is always incremented and never reset to 1
, when isRadical=1
, then tmp
is set to 0
for the given row only.
What's wrong in this command ?
Aucun commentaire:
Enregistrer un commentaire