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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well, I upgraded to MySQL 5 today.
I'm using MySql Query Browser.. I wonder if that has anything to do with it
I'm using MySql Query Browser.. I wonder if that has anything to do with it
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes, after I upgraded.
I'm not familiar with the MySQL monitor unfortunately, could you point me in the right direction please?
I'm not familiar with the MySQL monitor unfortunately, could you point me in the right direction please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Still looking for some time to spend on this. Just letting you know I'm not abandoning =)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
DELIMITER \\
I don't know what to do.