MySQL Forums
Forum List  »  Stored Procedures

Procedures or function using set command
Posted by: Phil Siyam
Date: January 24, 2022 07:35AM

Hi,
We recently upgraded from 8.0.24 to 8.0.26. Any procedures or function using set command are very slow and we have been changing set to into. E.g

-- Old Query
set var_1 = (select col1 from tab1 where col2 = 11);

-- New Query
select col1 into var_1 from tab1 where col2 = 11;


Is there better way to do it?

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Procedures or function using set command
310
January 24, 2022 07:35AM


Sorry, only registered users may post in this forum.

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.