The only solution you have: let your server-side procedure populate a temporary table and select from that when the procedure is complete. Depending on the thresholds you set in your mysql configuration, that memory table might very well reside in RAM anyhow. I doubt that speed will be an issue.
- michael dykman 2011/8/26 javad bakhshi <javadbakh...@yahoo.com> > > > Thanks guys for the help. but my problem seems to stand unsolved. > > > > ________________________________ > From: Johan De Meersman <vegiv...@tuxera.be> > To: Halász Sándor <h...@tbbs.net> > Cc: mysql@lists.mysql.com > Sent: Friday, August 26, 2011 7:04 PM > Subject: Re: Arrays > > ----- Original Message ----- > > From: "Halász Sándor" <h...@tbbs.net> > > > > Hi, I would like to create a function in Mysql that returns an Array > > of Numbers. I am trying to run a big amount of stream of data on > > Mysql and I can't afford the time to store the data into a table and > > retrieve it later. <<<<<<<< > > Are there any arrays at all in MySQL? > > Arrays; no. Functions can return simple numeric/string values; I'm not sure > wether or not you can return a recordset from a stored procedure. > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=javadbakh...@yahoo.com -- - michael dykman - mdyk...@gmail.com May the Source be with you.
