Simple Stored Procedure Broken

[spamguy]

I'm still trying to get the hang of stored procedures. In the constant cycle of revising a procedure, I need to drop a procedure if it's already in the database and add its replacement. Not hard. So what's wrong with this easy drop/add procedure sequence?

DROP PROCEDURE changeValue;
ADD PROCEDURE changeValue (IN val INT)
BEGIN
    SET val = val - 1;
END;

Each statement individually works, and I can't spot anything that would break the query above. Heck, I can't spot any differences between this and sample code.

[kaioshin00]

I'm still trying to get the hang of stored procedures. In the constant cycle of revising a procedure, I need to drop a procedure if it's already in the database and add its replacement. Not hard. So what's wrong with this easy drop/add procedure sequence?

DROP PROCEDURE changeValue;
ADD PROCEDURE changeValue (IN val INT)
BEGIN
    SET val = val - 1;
END;

Each statement individually works, and I can't spot anything that would break the query above. Heck, I can't spot any differences between this and sample code.

If I'm not mistaken, it's CREATE PROCEDURE, not ADD PROCEDURE

maybe that's the error?

[spamguy]

Oh god. *facepalm*

I must've started out with CREATE PROCEDURE (because it had processed earlier), and then changed it to ADD PROCEDURE along the line.

Thanks!

[spamguy]

OK, looks like I'm still stumped. This version, too, has a syntax problem I can't spot. Disregard the fact that inValue and dayCount don't do anything.

CREATE PROCEDURE myProc (IN inValue INT)
BEGIN
  DECLARE myCount INT;
END;

[pbmods]

Heya, Spamguy.

What is the full text of the error that MySQL is reporting?

[spamguy]

Hiya:

I'll pass it along when I get to the database tomorrow morning. But trying it on a second computer, it works. Doubly baffling!

[pbmods]

Heya, Spamguy.

Is the procedure already created on the other computer?

Try calling

DROP PROCEDURE myProc;

first.

[spamguy]

I...don't understand. I spent 15 minutes yesterday debugging this procedure before posting here. And now it works effortlessly. *sigh*

Thanks anyway.

[pbmods]

Heya, Spamguy.

Figure it this way:

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)