mercredi 17 juin 2015

Syntax error MySQL IF EXISTS

I have SQL query for voting, to check if vote alredy exists, but it keeps giving me syntax error near

IF EXISTS (SELECT * FROM `votes` WHERE `id` = 298 AND `author` = 'noo

Subquery itself runs fine.

IF EXISTS (SELECT * FROM `votes` WHERE `id` = 298 AND `author` = 'noob') THEN
    'exist'
ELSE
    INSERT INTO `votes`(`id`, `author`, `type`, `value`) VALUES (298, "noob", "upvote", 1)
    'upvoted'
END IF

Thanks for help

Aucun commentaire:

Enregistrer un commentaire