From: Michael Dykman Date: August 26 2011 11:16pm Subject: Re: Arrays List-Archive: http://lists.mysql.com/mysql/225595 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=90e6ba6e8ea887a19b04ab70ba4b --90e6ba6e8ea887a19b04ab70ba4b Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 i= n 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 > > > Thanks guys for the help. but my problem seems to stand unsolved. > > > > ________________________________ > From: Johan De Meersman > To: Hal=E1sz S=E1ndor > Cc: mysql@stripped > Sent: Friday, August 26, 2011 7:04 PM > Subject: Re: Arrays > > ----- Original Message ----- > > From: "Hal=E1sz S=E1ndor" > > > > 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 su= re > 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=3Djavadbakhshi@stripped --=20 - michael dykman - mdykman@stripped May the Source be with you. --90e6ba6e8ea887a19b04ab70ba4b--