RE: stored procedures in mysql5
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]
stored procedures in mysql5
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; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
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]
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]