Link to home
Start Free TrialLog in
Avatar of oxygen_728
oxygen_728

asked on

Error creating Stored Procedure in MySQL Query Browser

Hi. I keep getting an error when I try to create a Stored Procedure using MySQL Query Browser.

Steps:
- Script menu -> Create Stored Procedure
- Input Procedure name and click create procedure

In the code textbox I am given this:

DELIMITER \\

DROP PROCEDURE IF EXISTS `stock`.`DisplayINTC`\\
CREATE PROCEDURE `stock`.`DisplayINTC` ()
BEGIN
END\\

DELIMITER ;

When I hit execute, I get the error:

"
Line 1:  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 'DELIMITER \\    Errornr. 1064

DROP PROCEDURE IF EXISTS 'stock','DisplayINTC'\\
CREATE PROCEDU' at line 1"


My schema name is stock
My table name is full

even when i add the following line between the BEGIN & END statements, I get the same error:
  select Date, Price from full where symbol = "INTC";

Any ideas?

Thanks!
SOLUTION
Avatar of nagki
nagki

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oxygen_728
oxygen_728

ASKER

Bleh, I get an error even with:

DELIMITER \\


I don't know what to do.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Well, I upgraded to MySQL 5 today.

I'm using MySql Query Browser.. I wonder if that has anything to do with it
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
yes, after I upgraded.

I'm not familiar with the MySQL monitor unfortunately, could you point me in the right direction please?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Still looking for some time to spend on this. Just letting you know I'm not abandoning =)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial