MYSQL Mathematical Operations Priority

Question

this my code:

$stmt->prepare("UPDATE ".$PapierTableName."  SET nrating=nrating+1,`rating`=(rating+?)/nrating  WHERE `id`=? AND `title`=?");
$stmt->bind_param('iis', $rat,$id,$tit);

My question is about the priority: in this operation

`rating`=(rating+?)/nrating

the nrating that will be used is the one already incremented or the one that is present in column?
Thanks

score 1 · Accepted Answer · answered Apr 02 '13 at 09:50

1

That already incremented one; due to Operator Precedence

Parentheses may be used to force precedence, if necessary

answered Apr 02 '13 at 09:50

egig

4,370
5
29
50

So if I swap the operation the other one will be used,doesn't it? – Razorphyn Apr 02 '13 at 09:53
1

yep, if you reverse it, you will divide by the original value, and then increment it – Royal Bg Apr 02 '13 at 09:56

MYSQL Mathematical Operations Priority

1 Answers1