Announcement

Collapse
No announcement yet.

Problem importing Stored Procedures

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem importing Stored Procedures

    Hi,

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

    I found the reason in the stored procedures:


    /*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;


    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

    Comment


    • #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

      Comment

      Working...
      X