2011/09/02 06:09 -0700, javad bakhshi
Hi, None of the above. :) .This is just an academic research on a benchmark. I
just want to access my database with this function and return 4 Integer values.
I separated the numbers with comma to process on it later as an string and
split the resu
Javad
From: Shawn Green (MySQL)
To: javad bakhshi
Cc: "mysql@lists.mysql.com"
Sent: Friday, September 2, 2011 2:18 PM
Subject: Re: Arrays
Hello Javad,
On 9/2/2011 05:51, javad bakhshi wrote:
> Hi again,
>
> Thanks for the tips. My problem is:
> I have a Function in My
Hello Javad,
On 9/2/2011 05:51, javad bakhshi wrote:
Hi again,
Thanks for the tips. My problem is:
I have a Function in Mysql that has some arguments in the signature as
follows:
CREATE FUNCTION Myfunction( type TINYINT, sec SMALLINT, vid INTEGER,
way TINYINT, quid INTEGER, day TINYINT )
RETUR
Best regards,
Javad
From: Shawn Green (MySQL)
To:
Cc: javad bakhshi ; Johan De Meersman
; "mysql@lists.mysql.com"
Sent: Monday, August 29, 2011 4:51 PM
Subject: Re: Arrays
On 8/27/2011 11:18, wrote:
>>>>> 2011/08/26 13:58 -0700, javad bakhshi>>>&g
On 8/27/2011 11:18, wrote:
2011/08/26 13:58 -0700, javad bakhshi
Thanks guys for the help. but my problem seems to stand unsolved.
Right, no arrays. Nothing is left but table. I used a temporary table, but note
that MySQL also does not let table be returned, or passed in. The ta
2011/08/28 09:36 +0200, Johan De Meersman
No: when you use /create temporary table/, the table is local to your
connection. You can perfectly open a dozen connections and have them all create
a temporary table called intermediate_results, they'll not interfere with one
another. Tempora
2011/8/27 Halász Sándor
> 2011/08/26 13:58 -0700, javad bakhshi
> Thanks guys for the help. but my problem seems to stand unsolved.
>
> Right, no arrays. Nothing is left but table. I used a temporary table, but
> note that MySQL also does not let table be returned, or passed
- Original Message -
> From: "Arthur Fuller"
> Another approach to this is to create a concatenated string from the
> PKs of the result set and then parse that within a stored procedure
> elsewhere in your Front End (FE). For more information on this,
> visit www.artfulsoftware.com and c
- Original Message -
> From: "Halász Sándor"
>
> passed in. The table-name will be *sigh* global.
No: when you use /create temporary table/, the table is local to your
connection. You can perfectly open a dozen connections and have them all create
a temporary table called intermediate
Another approach to this is to create a concatenated string from the PKs of
the result set and then parse that within a stored procedure elsewhere in
your Front End (FE). For more information on this, visit
www.artfulsoftware.com and check out the Queries page.
Arthur
2011/08/26 13:58 -0700, javad bakhshi
Thanks guys for the help. but my problem seems to stand unsolved.
Right, no arrays. Nothing is left but table. I used a temporary table, but note
that MySQL also does not let table be returned, or passed in. The table-name
will be *sigh* g
.
- 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ász Sándor
> Cc: mysql@lists.mysql.com
> Sent: Friday, Augu
 Thanks guys for the help. but my problem seems to stand unsolved.
From: Johan De Meersman
To: Halász Sándor
Cc: mysql@lists.mysql.com
Sent: Friday, August 26, 2011 7:04 PM
Subject: Re: Arrays
- Original Message -
> From: "Halász
- Original Message -
> From: "Halász Sándor"
>
> 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.
>
2011/08/24 02:05 -0700, javad bakhshi
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 arra
My question is how do I send multiple sets of data into a stored
procedure
without doing the things I had outlined.
MySQL doesn't have arrays. Pass the data in a comma-delimited string
and PREPARE the statement, or pass it as a temp memory table.
PB
-
L P wrote:
Chris,
thank you fo
Chris,
thank you for the response, but that was not my question.
My question is how do I send multiple sets of data into a stored procedure
without doing the things I had outlined.
On 7/17/06, Chris <[EMAIL PROTECTED]> wrote:
L P wrote:
> Folks,
> say I have a need to add multiple rows at the
L P wrote:
Folks,
say I have a need to add multiple rows at the same time.
for instance, say I'm collecting customer information and I want to add 3
addresses and 3 phone numbers at the same time for a customer.
The above is quite straightforward to accomplish when there is only one set
of data
18 matches
Mail list logo
