Stored procedure syntax error in MySQL

Question

I am searching the error for two hours, yet I can't find so far:

CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_diffmod`
     (IN para_diffmod LONGTEXT, 
      IN para_link LONGTEXT)
BEGIN

IF EXIT (
    SELECT website_link FROM diffmod WHERE website_link=para_link
    )THEN 
    DELETE FROM diffmod WHERE website_link=para_link;

ELSE
    INSERT INTO diffmod(website_id,website_link)
    SELECT id,link
    FROM   site_html
    Where  link=para_link;

    UPDATE diffmod
    SET diffmod_content= para_diffmod
    where website_link = para_link;

END IF; 
END

The above stored procedure works as if the link found, it will delete the row! If not, it will add and update the new link.

Akshey Bhat · Accepted Answer · 2016-06-14 07:34:19Z

1

Change If EXIT to IF EXISTS

CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_diffmod`( 
IN para_diffmod LONGTEXT, 
IN para_link LONGTEXT)
BEGIN

IF EXISTS (
    SELECT website_link FROM diffmod WHERE website_link=para_link
    )THEN 
    DELETE FROM diffmod WHERE website_link=para_link;

ELSE
    INSERT INTO diffmod(website_id,website_link)
    SELECT id,link
    FROM   site_html
    Where  link=para_link;

    UPDATE diffmod
    SET diffmod_content= para_diffmod
    where website_link = para_link;

END IF; 
END

answered Jun 14, 2016 at 7:34

Akshey Bhat

8,6872 gold badges24 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Achilles Over a year ago

can i know what did i miss out?

Akshey Bhat Over a year ago

"If exists" clause is used for checking if query is returning any rows. You had "If exit" in place of "if exists"

Achilles Over a year ago

Oh man ! missing 's' and looking for 2 hour . Thanks a lot. Appreciate it.

Akshey Bhat Over a year ago

@Achilles please mark my answer as correct if you feel it solved your problem

Collectives™ on Stack Overflow

Stored procedure syntax error in MySQL

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related