MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION
Posted by: Nestor Pedraza
Date: March 05, 2022 10:46PM

Sorry I've posted a wrong code . This is the one IT's not working . DOER is the date field in the table


CREATE DEFINER=`myNestor`@`%` FUNCTION `EURO`(FEC DATE ) RETURNS decimal(11,2)
BEGIN
SET @TODAY=FEC;
SELECT EURO FROM DATA.IYM WHERE DOER=@TODAY INTO @RESULT ;
RETURN @RESULT ;
END

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION
2429
Nestor Pedraza
March 05, 2022 07:09PM
Re: Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION
1123
Peter Brawley
March 05, 2022 08:19PM
Re: Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION
849
Nestor Pedraza
March 05, 2022 10:46PM
Re: Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION
989
Peter Brawley
March 14, 2022 11:12AM


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.