MySQL function error

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
dear all,

I have a table called "distributor" having "distributor_id" as a PK
and taking an integer data type as well as "distributor_parent_id"
which also takes an integer data type but can accept null values;

I tried to make this simple function that returns the parent_id by
taking a parameter representing the distributor id; still it fails, I
assume due to the delimiters.

I appreciate any assistance to this regard.


CREATE FUNCTION last_inserted_parent_id ( inserted_id INT )
        DECLARE parent_id INT$$
        SET parent_id = (
                                SELECT distributor_parent_id
                                FROM distributor
                                WHERE distributor_id = inserted_id
        RETURN parent_id$$


Re: MySQL function error

Quoted text here. Click to load it

Hi Coosa,

Welcome to comp.lang.php where all things PHP get discussed. But we
tend not to talk about things which are nothing to do with PHP.

Try this list for more suitable places to post your query:


Re: MySQL function error

coosa wrote:
Quoted text here. Click to load it

comp.databases.mysql is thataway ==>.

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline