Marc, this SP section of the docs did not come with the 5.0 downlaod, thanks for the url! PB ----- Original Message ----- From: Mechain Marc To: Peter Brawley ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:09 AM Subject: RE: MYSQL 5 Stored Procedure
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]
