MySQL Forums
Forum List  »  French

create function
Posted by: dedalios dedalios
Date: February 23, 2009 03:58PM

CREATE function serve/DBEE_Naiss()
RETURNS TABLE( Tema VARCHAR(150))
LANGUAGE SQL
READS SQL DATA
NO EXTERNAL ACTION
NOT DETERMINISTIC
DISALLOW PARALLEL

Begin
Declare aleas integer;
set aleas = integer(rand() * 100);

return
SELECT ZNTABLE
FROM DBEE
WHERE TYPETABLE = 'Naissance'
and aleas between VMIN and VMAX ;
end
Cette fonction marche sous IBMDB2 . j'aimerai la transpose sous mysql 5.1.
Est-ce possible ? Moi je ne trouve pas.

Options: ReplyQuote


Subject
Views
Written By
Posted
create function
6283
February 23, 2009 03:58PM
2957
March 17, 2009 11:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.