Re: MYSQL 5 Stored Procedure

2004-01-07 Thread Gerald Jensen 
Do a search on this list ... this has been covered within the last two weeks
several times.

- Original Message - 
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 5:40 AM
Subject: MYSQL 5 Stored Procedure


 Hello
 I've installed Mysql 5 and have created a database. When I try and create
a stored procedure (using the example in the help) it fails.
 The online help states that there should be a table called 'procs' in the
database for stored procedures to work. I can't see this table. The help
says this should have been created as part of the installation.

 Any ideas as to why this is and what I can do?

 Thanks

 -
 Email provided by http://www.ntlhome.com/



 -- 
 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: MYSQL 5 Stored Procedure

2004-01-07 Thread Mechain Marc 

Documentation:

http://www.mysql.com/doc/en/Stored_Procedures.html

Marc.

-Message d'origine-
De : Peter Brawley [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 7 janvier 2004 16:32
À : [EMAIL PROTECTED]; [EMAIL PROTECTED]
Objet : Re: MYSQL 5 Stored Procedure


Matthew,

You need to run the script mysql_fix_privilege_tables.sql. It's not included in some 
binaries, but it is in 5.0 source archives. Once you run this script, you can execute 
Create Procedure ... as a SQL cmd.

How you execute them, though, is not mentioned yet in the docs :-).

PB
- Original Message - 
From: [EMAIL PROTECTED] 
To: [EMAIL PROTECTED] 
Sent: Wednesday, January 07, 2004 5:40 AM
Subject: MYSQL 5 Stored Procedure


Hello
I've installed Mysql 5 and have created a database. When I try and create a stored 
procedure (using the example in the help) it fails. 
The online help states that there should be a table called 'procs' in the database for 
stored procedures to work. I can't see this table. The help says this should have been 
created as part of the installation.

Any ideas as to why this is and what I can do?

Thanks

-
Email provided by http://www.ntlhome.com/



-- 
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]


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