[Question] An error

03/11/2010 23:40 [GM]Death[PM]#1

I am well aware there is another topic with this discussion but from what I read it does not give an exact reason or a good solution to the problem.

[SQL] Update cq_eudemon_rbn_rqr set min=*2;
[Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '*2' at line 1

I received this error after trying to x2 the compose rates . If you have any information it would be helpful and please this time actually read and not jump the gun thinking you know what it is. Last post I had a few replies that weren't even helpful let alone on topic of the issue. Thank you.

03/12/2010 00:05 ~WARNING~#2

Try this

Code:

update cq_eudemon_rbn_rqr set min=min*2
update cq_eudemon_rbn_rqr set max=max*2

use it the exact way i have it

03/12/2010 00:13 [GM]Death[PM]#3

The error still continues to show up when I run the query.

03/12/2010 00:27 ~WARNING~#4

opps =P forgot the ; xD

Code:

update cq_eudemon_rbn_rqr set min=min*2;
update cq_eudemon_rbn_rqr set min=ax*2;

03/12/2010 01:21 King_Arthur#5

Quote:
Originally Posted by ibeatuall
opps =P forgot the ; xD
Code:
update cq_eudemon_rbn_rqr set min=min*2;
update cq_eudemon_rbn_rqr set m[COLOR="Red"]ax[/COLOR]=[COLOR="Red"]m[/COLOR]ax*2;

Re-Fixed

03/12/2010 01:50 [GM]Death[PM]#6

Thank you both. =)