MySQL Forums
Forum List  »  Newbie

Returning COUNT() as a variable
Posted by: Michael Smith
Date: March 26, 2023 03:52PM

I have read a number of documents on this topic and I don't think I have anything that works.

Here is one variation:

SELECT COUNT(*) FROM Invoices01 INTO @V1;

Idea is I could check @V1 to see how big it is.

But I don't think this is working properly. Its part of a stored procedure.

Is this good code?

Mike

Options: ReplyQuote


Subject
Written By
Posted
Returning COUNT() as a variable
March 26, 2023 03:52PM


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.