Is it possible in SQL to develop a subroutine in some way?

I've got a Java function (formula) I'd like to implement into a Select
query to compute a column, but (If I'm reading the manual correctly)
I'd rather not have to recompile the entire database and redevelop the
entire application to get a single formula included.

This will be implemented in a PHP environment and web accessible,

Anyone have any possible ideas?

On 10/11/2010 2:06 PM, Charles wrote:
I don't understand your question. You don't "compile a database". But
there are MySQL functions to perform some calculations. You can also
define your own stored programs and/or functions to perform required
tasks and add them to your database.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Charles wrote:

its not necessary to recompile the entire database engine. You can also
store user procedures and dynamically link them, it seems.

I've no idea how to go about it though. RTFM?

Charles <cchamb2 (AT) gmail (DOT) com> wrote:

MySQL 5.0 and later supports stored routines (functions and
procedures). Those are written in some PL/SQL derivative.

Looks like you already found user defined functions (UDF)
which are written in C/C++ and typically compiled to a shared
library and loaded at runtime.

Stored routines are much easier to use!

http://dev.mysql.com/doc/refman/5.1/...-routines.html

Neither way you can execute any Java code in the MySQL server.
But how complicated can that "formula" be, that you can't
express it in SQL?


XL

On 11/10/10 20:06, Charles wrote:
I do not see exactly what you want. If you really want to run it on the
database server, there are a few options. In addition to the already
given suggestions, you can use prepared statements if the formula varies.

But if you just have a program that reads data from a database and
processes it, I would say that you would best apply your function after
reading in the query results, in the program and not in the query on the
database server.

Good luck,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

On Oct 12, 12:09*am, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:
Quite.

http://www.movable-type.co.uk/script...-vincenty.html

On Oct 12, 1:07*am, Willem Bogaerts <w.bogae... (AT) kratz (DOT) nl> wrote:
The function I want to implement takes the GPS latitude/longtitude and
computes the distance between them.

What I'm looking for is coding so that I can:

SELECT * FROM table1 WHERE column9 = function(COL5, COL6, COL7, COL8)

and possible pass two constants as parameters so that I don't have
this problem again.

Charles <cchamb2 (AT) gmail (DOT) com> wrote:
1. this is not complicated
2. this can be expressed in PL/SQL
3. this is rather senseless IMHO

4. comparing floating point numbers for equality is foolish

Looks like a perfect fit for a stored function. RTFM!


XL

Charles <cchamb2 (AT) gmail (DOT) com> writes:

You're kidding, right? That's just a loop and a few calls to built-in
trig functions. It's well within the capabilities of an SQL procedure.

sherm--

--
Sherm Pendley
<http://camelbones.sourceforge.net>
Cocoa Developer

On Oct 12, 7:37*am, Sherm Pendley <sherm.pend... (AT) gmail (DOT) com> wrote:
Which was the original purpose of the question - to make sure it can
be done and maybe a hint or suggestion as to direction in which to
find it.