Re: MySQL function error
- From: Jerry Stuckle <jstucklex@xxxxxxxxxxxxx>
- Date: Thu, 08 Nov 2007 08:45:00 -0500
coosa wrote:
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.
DELIMITER $$
CREATE FUNCTION last_inserted_parent_id ( inserted_id INT )
RETURNS INT
BEGIN
DECLARE parent_id INT$$
SET parent_id = (
SELECT distributor_parent_id
FROM distributor
WHERE distributor_id = inserted_id
)
RETURN parent_id$$
END$$
DELIMITER ;
comp.databases.mysql is thataway ==>.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.
- References:
- MySQL function error
- From: coosa
- MySQL function error
- Prev by Date: Re: Rate a page (like in you tube)
- Next by Date: Re: mySQL Problem
- Previous by thread: Re: MySQL function error
- Index(es):
Relevant Pages
|
