MySQL Forums
Forum List  »  Stored Procedures

Problem Stored Procedure Count
Posted by: re der
Date: May 05, 2013 07:01AM

Hello
this is my first post.
I'm migrating a query this on an ASP page to the MySQL engine, with phpmyadmin.

The problem is that I do not get any results, where am I wrong?
This is the SP:

DELIMITER $$
DROP PROCEDURE IF EXISTS `anc_ese`.`sp_count_soci_italia` $$
CREATE PROCEDURE `sp_count_soci_italia`(
IN stranno VARCHAR(10),
OUT TotalCount INT
)
BEGIN
SELECT COUNT(*)
INTO TotalCount
FROM soci
WHERE datai like CONCAT('%', @stranno, '%');
SELECT @TotalCount;
END $$
DELIMITER ;



Edited 1 time(s). Last edit at 05/05/2013 07:10AM by re der.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem Stored Procedure Count
2029
May 05, 2013 07:01AM
796
May 05, 2013 04:25PM
788
May 06, 2013 10: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.