I am trying to invoke a Procedure which as Query type as input parameter in C# using mysql connector. Can anyone guide how to achieve this?
here is a sample procedure I created
CREATE OR REPLACE PROCEDURE sampletableproc(sampledata query(idd int))
echo SELECT id,fullname FROM sampletable a join sampledata sd on a.id = sd.idd;
I tried to run below statement but getting an error
DECLARE v QUERY(a INT) = select 1;
how do we execute this in studio and C#?