sorry insane is ozzy slang for awesome, the best whatever u want to call it .
well , ok from what i know and have asked about , they are precompiled functions , actually embedded into the server which do routines , so therefore all u have to do is call the procedure from the API, therefore ok now its standardised , makes it modular , therefore all u need to do is change the function if any changes are to be made , but i guess how the hell do u "recompile", as in completely recompile the source , or just restarting the server? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 8:14 AM To: electroteque; [EMAIL PROTECTED] Subject: Re: stored procedures in mysql5 "insane" you mean extremely fast? or easy to use? i'd like to know what those SPs are good for... -yves -----Ursprüngliche Nachricht----- Von: "electroteque" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Montag, 30. Juni 2003 00:09 Betreff: RE: stored procedures in mysql5 > thanks this is pretty insane cant wait for its release :D > > -----Original Message----- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 6:07 AM > To: electroteque > Cc: Mysql > Subject: Re: stored procedures in mysql5 > > > On Sun, Jun 29, 2003 at 08:00:29PM +1000, electroteque wrote: > > ok i have a bleeding edge server instance on my server apache2/php5/mysql5 > > running alongside the stable server , is stored procedures actually > > functioning in it yet ? is this the correct syntax there is no > documentation > > for it yet. > > create procedure test as select * from tablename; > > There are a lot of SP examples in the source distribution or BK tree. > > Have a look at mysql-test/t/sp.test. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 26 days, processed 826,793,662 queries (360/sec. avg) > > -- > 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]