problem for cq_eudemon_rbn_rqr

10/28/2014 20:55 glmod10#1

welcome all
i have problem :
when need add new number of cq_eudemon_rbn_rqr for example 3 in type reborn rqe navicat send me thats problem what i can do for thats problem

[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 ''3)' at line 1

10/28/2014 21:48 idlemonkey#2

post your sql.... it should looks something like this

Code:

UPDATE cq_eudemon_rbn_rqr SET cq_eudemon_rbn_rqr.max = cq_eudemon_rbn_rqr.max + 3;
UPDATE cq_eudemon_rbn_rqr SET cq_eudemon_rbn_rqr.min = cq_eudemon_rbn_rqr.min + 3;

or this

Code:

UPDATE `my`.`cq_eudemon_rbn_rqr` SET max = max + 3;
UPDATE `my`.`cq_eudemon_rbn_rqr` SET min = min + 3;

the error just says that you wrote your sql wrong and its not proper for the mysql version you are using

10/28/2014 22:08 glmod10#3

thx very match

What I want is to put 2 query 1 easy and 1 hared Easy takes a value of 1 difficult take a value 2 or 3 in rbr_rqr_type

10/29/2014 00:48 idlemonkey#4

simple easier is a higher number