mySql :: error in general variable error

Question

Possible Duplicate:
MySQL - Syntax Error in Strored Procedure

Thanks, but if use variable :::::like this :

 IF NOT EXISTS( SELECT ReferenceID as ExistedRefID  FROM filesrefrences WHERE RefrenceKey= pRefrenceKey) THEN
        INSERT INTO filesrefrences(RefrenceKey, RefrenceCount)
        VALUES(pRefrenceKey,1);
       SELECT LAST_INSERT_ID();
    ELSE
        UPDATE filesrefrences
        SET RefrenceCount= RefrenceCount+1
        WHERE ReferenceID= ExistedRefID;
        SELECT ExistedRefID;
    END IF

it refers executing error that ExistedRefID is uknown, how could i solve this

Don't add same question again you can get answer on the same question. You r last question is http://stackoverflow.com/questions/14134105/mysql-syntax-error-in-strored-procedure — Saharsh Shah, Jan 03 '13 at 07:00
sorry but i add it as an answer for the last Q. anyway I'm very grateful for your answer — Raed Alsaleh, Jan 03 '13 at 07:05
Remove this question from here and communicate on your last question for thew same. — Saharsh Shah, Jan 03 '13 at 07:13

score 0 · Answer 1 · answered Jan 03 '13 at 07:02

0

Why not just:

insert into filesreferences (RefrenceKey, RefrenceCount) values (pRefrenceKey, 1)
    on duplicate key update RefrenceCount= RefrenceCount+1;

answered Jan 03 '13 at 07:02

ysth

96,171
6
121
214

but RefrenceKey is not primary key... does it valid – Raed Alsaleh Jan 03 '13 at 07:03
ah; it helps to give your actual table structure when you ask questions. it should still work if RefrenceKey is a unique index. – ysth Jan 03 '13 at 07:04
Ok.. I will make it as unique index ... thankyou – Raed Alsaleh Jan 03 '13 at 07:07

mySql :: error in general variable error

1 Answers1