Menu

#2111 (ok 2.9.0) Can\'t create store procedure

2.8.0.3
fixed
1
2013-06-11
2006-04-13
BIGGIO LAI
No

When running below sql query in PHPmyadmin:

-----------------
DELIMITER $$

CREATE PROCEDURE `procedurename`()
BEGIN
SELECT * FROM tablename;
END $$

DELIMITER ;

---------------------
SQL syntax error

Below query doesn't work also
-----------------
CREATE PROCEDURE `procedurename`()
BEGIN
SELECT * FROM tablename;
END;
-----------------

Discussion

  • Marc Delisle

    Marc Delisle - 2006-06-06
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2006-06-09
    • assigned_to: lem9 --> nobody
     
  • Marc Delisle

    Marc Delisle - 2006-06-13
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2006-06-13

    Logged In: YES
    user_id=210714

    Fix implemented in current HEAD CVS with a new Delimiter
    field in the query form, please test. TODO: the
    after-execution display of this kind of query is empty.

     
  • Marc Delisle

    Marc Delisle - 2006-06-21
    • priority: 5 --> 1
    • summary: Can't create store procedure --> (ok 2.9.0) Can't create store procedure
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2006-09-20
    • summary: (ok 2.9.0) Can't create store procedure --> (ok 2.9.0) Can\'t create store procedure
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed