MySQL Forums
Forum List  »  MySQL Query Browser

Query Browser Tool !!!
Posted by: hi jacker
Date: October 13, 2005 02:49PM

Hi, maybe someone can help me solve my problem !

I'm using mySQL 5 and i'm trying to create some stored procedures.

Does anyone know what do I have to do, to make "MySQL Query Browser" works like if i was using the mySQL console ?

Cause, when i try to run this code at the "MySQL Query Browser" or another mySQL query tool:

DELIMITER |
DROP PROCEDURE IF EXISTS sp_declare\G|
CREATE PROCEDURE sp_declare (P INT)
BEGIN
DECLARE x INT;
DECLARE y INT DEFAULT 10;
SET x = P*y;
SELECT x;
END|
DELIMITER ;

I get several errors.

BUT, if i paste this inside the mySQL console it works FINE !

What do i have to do to make "MySQL Query Browser" works just like the console ?

Thanks in advance

· H1J4CK3R ·

Options: ReplyQuote


Subject
Written By
Posted
Query Browser Tool !!!
October 13, 2005 02:49PM
October 14, 2005 01:06AM
October 14, 2005 01:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.