My Bad. I was all into 4.xx and since most of the www.mysql.com references 4.xx I never
thought about
5.0. I appologize for disturbing the list.
thank you,
raymond
-----Original Message-----
From: V. M. Brasseur [mailto:brasseur@stripped]
Sent: Tuesday, August 31, 2004 18:54
To: Jacob, Raymond A Jr
Cc: mysql@stripped
Subject: Re: Is their still any reason why Stored Procedure calls are
not supported in MySql?
Stored procedures are in the works for MySQL 5.0:
http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html
The manual is your friend.
Cheers,
--V
Jacob, Raymond A Jr wrote:
> Firstly,
> I do appologize for my ignorance in advance. I read the message regarding
> PRODUCT() and
> thought to myself:"A perl interpreter can be run in a C program. Some one must have
> written
> a userdefined function that can execute perl code. Googling I found
> http://software.tangent.org/download/myperl-0.8.tar.gz at http://tangent.org.
> Looking at the readme file myperl is mysql userdefined function that executes
> perl code contained in a table in the select statement. The command line
> version of mysql also has the ability to start an editor. Theoretically,
> one could:
> 1. create a table:
> Create table user.sparky.functions
> ( name TEXT NOT NULL , code TEXT NOT NULL );
> 2. \e myfunc.mypl
> 3. LOAD DATA IN FILE myfunc.mypl
> INTO TABLE user.sparky.functions;
> 4. /* assume no errors */
> Select myfunc(code, colum_data)
> from user.sparky.functions, data_table
> where (code = myperl_code ) and
> ( column_data = "what I am looking for" );
>
> If and I stress if my assumptions are valid, then stored procedure calls could be
> written in any interpreted language with an interpreter that can be linked into
> mysql. Of course from a security stand point this could be dangerous but
> chrooted brain dead interperter with limited functionality and limits
> on the amount of disk space and memory that can be used should solve those problems.
> One interesting consequence of the development of infrastructure to support
> the development of stored procedure calls is that IDE developers that support
> mysql would have new market to potentially exploit in a corporate enviroment
> i.e. run code and get metrics such as how long it to process data i.e. Hi,Lo, Avg.
> In conclusion, I appologize for my ignorance again however I must still ask:
> Is their still any reason why Stored Procedure calls are not supported in MySql?
> Thank you,
> Raymond
> ------------------------------
> Date: Mon, 30 Aug 2004 11:29:35 -0400
> To: "Thomas Schager" <thomas.schager@stripped>,
> <mysql@stripped>
> From: "Sapenov" <sapenov@stripped>
> Subject: Re: "PRODUCT()" function - calculating the product of grouped numeric
> values
> Message-ID: <001001c48ea6$27c67790$ab00a8c0@DEVELOPER>
> Hello Thomas,
> You probably may consider to write a UDF to do that.
> Here is a list of available UDF extensions for 4.0.20 -
> http://mysql-udf.sourceforge.net/
> Regards,
> Khazret Sapenov
> -------------------------------------
> http://tangent.org
> myperl (default) 0.8
> 2004-01-12 07:58:51
> About myperl allows you to execute Perl from inside of MySQL. It can either be stored
> in a row, or it can be specified in your SQL statement. You also can select other columns
> which will be passed to Perl.
>
> Changes * Added support for the perl interpreter to persist for requests
>
> * re-aranged package to meet CPAN spec.
>
> * Fix for myperlgroup (it was calling itself too frequently)
>
> TAR/GZ
> http://software.tangent.org/download/myperl-0.8.tar.gz
>
> ------------------------------
>
> Date: Mon, 30 Aug 2004 09:48:55 -0400
> To: Per Lonnborg <perlon@stripped>
> From: Michael Stassen <Michael.Stassen@stripped>
> CC: mysql@stripped
> Subject: Re: SELECT, ORDER & one DISTINCT kolumn?
> Message-ID: <41333047.3080109@stripped>
>
> Per Lonnborg wrote:
>
>>Hi,
>>
>>Here´s a question from a newbie:
>>
>>I have a database containing ET-times for drivers and their cars.
>>On the web startpage (http://www.lanechoice.net/~pelle/br/) i have made
>>a "Top-10" list containing the 10 fastest times.
>
>
> I'll guess column names based on the web page.
>
>
>>I have 2 problems:
>>
>>1. How to select just ONE (the fastest of course) time per uniqe driver&car?
>
>
> SELECT namm, fabrikat, MIN(tid) AS fastest_tid
> FROM ettan
> GROUP BY namm, fabrikat
> ORDER BY fastest_tid DESC LIMIT 10;
>
>
>>2.IF the driver/car has run some race faster than 7,5 secs, he/she is
> disqualified
>>and should not be on the "Top-10" at all.
>
>
> SELECT namm, fabrikat, MIN(tid) AS fastest_tid
> FROM ettan
> GROUP BY namm, fabrikat
> HAVING fastest_tid >= 7.5
> ORDER BY fastest_tid LIMIT 10;
>
>
>>The query I use right now is:
>>
>>Select * from ettan where tid >=7.5 ORDER BY tid LIMIT 10
>>
>>/Per
>>Stockholm, Sweden
>
>
> Note that I only selected aggregate values and grouped columns. If you need
> the values of non-grouped columns (ort, datum, 60fot, hast) which correspond
> to the minimum times, you'll need to do a bit more. The manuaal describes 3
> methods
> <http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html>.
>
>
>>_______________________________________________________
>>Skicka gratis SMS!
>>http://www.passagen.se
>
>
> Michael
>
> ------------------------------
>
>
> ------------------------------
>
> End of mysql-plain Digest
> ***********************************
>
