Using CREATE PROCEDURE/FUNCTION

2004-08-25 Thread Marti Quixal 
Hi!
Anybody knows how to use CREATE PROCEDURE and CREATE FUNCTION in 
4.1.1-alpha-Max.

I keep trying the CREATE PROCEDURE and CREATE FUNCTION examples found in 
the MySQL web documentation, but there's no way to make it work. It 
always prompts problems with syntax. Is delimiter a function working 
in all versions of MySQL? Is there a bug in this version? Any helping hand?

Thanks!
Marti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Using CREATE PROCEDURE/FUNCTION

2004-08-25 Thread Boyd E. Hemphill 
Marti:

Stored procedures are new in version 5.0.


Best Regards,
Boyd E. Hemphill
MySQL Certified Professional
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O:  (512) 248-2287
M:  (713) 252-4688

-Original Message-
From: Marti Quixal [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 25, 2004 8:23 AM
To: [EMAIL PROTECTED]
Subject: Using CREATE PROCEDURE/FUNCTION

Hi!
Anybody knows how to use CREATE PROCEDURE and CREATE FUNCTION in 
4.1.1-alpha-Max.

I keep trying the CREATE PROCEDURE and CREATE FUNCTION examples found in 
the MySQL web documentation, but there's no way to make it work. It 
always prompts problems with syntax. Is delimiter a function working 
in all versions of MySQL? Is there a bug in this version? Any helping hand?

Thanks!
Marti


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using CREATE PROCEDURE/FUNCTION

2004-08-25 Thread Terry Riley 
I think you'll find that 'create procedure' and 'create function' don't 
appear until version 5.0 of MySQL.

Which is why you get a syntax (are you sure you have the right version?) 
error.

Regards
Terry

- Original Message -

 Hi!
 Anybody knows how to use CREATE PROCEDURE and CREATE FUNCTION in 
 4.1.1-alpha-Max.
 
 I keep trying the CREATE PROCEDURE and CREATE FUNCTION examples found 
 in the MySQL web documentation, but there's no way to make it work. It 
 always prompts problems with syntax. Is delimiter a function working 
 in all versions of MySQL? Is there a bug in this version? Any helping 
 hand?
 
 Thanks!
 Marti
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]