Problem importing Stored Procedures

Developers Installing PHP / Apache / IIS / Environment
#1

Hi,

i want to start the script case training, but i have problems importing the mysqlfile.

I found the reason in the stored procedures:

[sup]/procedures/

CREATE PROCEDURE INSERT_CATEGORIES(IN CategoryName VARCHAR(15), IN Description TEXT, IN Picture VARCHAR(50))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
INSERT INTO categories(CategoryName,Description,Picture)values(CategoryName,Description,Picture);
END;

CREATE PROCEDURE UPDATE_CATEGORIES(IN CategoryID INTEGER ,IN CategoryName VARCHAR(15), IN Description TEXT, IN Picture VARCHAR(50))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
UPDATE categories SET CategoryName = CategoryName,Description = Description,Picture = Picture
WHERE CategoryID = CategoryID;
END;

CREATE PROCEDURE DELETE_CATEGORIES(IN CategoryID INTEGER)
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
DELETE FROM categories WHERE CategoryID = CategoryID;
END;
[/sup]

There always comes the failure:

#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 ‘’ at line 6

Any Ideas?
Thanks
Norman

#2

Re: Problem importing Stored Procedures

It was solved removing all “;” of the END.

/procedures/

CREATE PROCEDURE INSERT_CATEGORIES(IN CategoryName VARCHAR(15), IN Description TEXT, IN Picture VARCHAR(50))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
INSERT INTO categories(CategoryName,Description,Picture)values(CategoryName,Description,Picture);
END

CREATE PROCEDURE UPDATE_CATEGORIES(IN CategoryID INTEGER ,IN CategoryName VARCHAR(15), IN Description TEXT, IN Picture VARCHAR(50))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
UPDATE categories SET CategoryName = CategoryName,Description = Description,Picture = Picture
WHERE CategoryID = CategoryID;
END

CREATE PROCEDURE DELETE_CATEGORIES(IN CategoryID INTEGER)
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
DELETE FROM categories WHERE CategoryID = CategoryID;
END

#3

Re: Problem importing Stored Procedures

I would not have thought that would have fixed the problem.

There is a better way that the file should be set up to import properly, and if you decide that you are having problems still, let me know and I can put the example here.

Alan