how to get output value in from procedure in mysql

Question

CREATE DEFINER=`root`@`localhost` PROCEDURE `test`(out myvalue int)
BEGIN
select count(*) from EventList_View group by eventId  into myvalue  ;
END

this is my Procedure i am calling this Procedure call test(@output); select @output; like this but i am unable to get value of output parameter as myvalue . while i am trying to execute select count(*) from EventList_View group by eventId this query i am getting value 5 please tell me how to get output value where am doing wrong in procedure .

Do Tag which are related only to your Question. I think SQL Server Tag doesn't suits your query. — Shakeer Mirza
– Shakeer Mirza, Commented Oct 20, 2016 at 4:46
That is a horrible select stmt you have going there. Do you see why? — Drew
– Drew, Commented Oct 20, 2016 at 5:14
Well then let me tell ya. When you have more than one value of eventId in the table, you will get Error Code: 1172. Result consisted of more than one row — Drew
– Drew, Commented Oct 20, 2016 at 5:22

Research Development · Accepted Answer · 2016-10-20 05:38:11Z

2

CREATE DEFINER=`root`@`localhost` PROCEDURE `test`(out myvalue int)
BEGIN
select count(*) from (select * from events group by event_id) as totalcount into myvalue;


END

apply this query

answered Oct 20, 2016 at 5:38

Research Development

9041 gold badge19 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to get output value in from procedure in mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related