assinment operators in mysql
Posted: Tue Jun 29, 2004 1:00 pm
Is there any way to use basic mathamatics in your mysql queries? The following doesnt work for me, but is basicly what I am trying to acomplish:
I'm probably doing it wrong. If mysql doesnt have anything like this, then I will just have to do it from php
. Not the worst news ever, but still...
if anybody knows thhe answer to this then please tell me.
Thanks.
Code: Select all
update users set whatever +=12 where user_id=1if anybody knows thhe answer to this then please tell me.
Thanks.