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
a web page? All of this SQL coding is designed to be a single
step in some larger process. If you share that larger purpose with us,
we may be able to suggest a more efficient approach than arrays to solve
your larger problem.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Or
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
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, b
- 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 retur
st 26, 2011 7:04 PM
> Subject: Re: Arrays
>
> - 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
> > My
 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
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
later. <<<<<<<<
Are there any arrays at all in MySQL?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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. Is there any
solutions?Â
Â
Best regards,
Javad Bakhshi,
Computer Scien
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,
than
mysql.com/doc/refman/5.1/en/insert.html
Don't use arrays for storage, you'll lose a lot of performance.
http://dev.mysql.com/doc/refman/5.1/en/insert.html
Don't use arrays for storage, you'll lose a lot of performance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 to deal wit
Hi Kaan
try
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
$testA=implode("!", $testArray);
echo "";
Page2
$testArray=explode("!", $kcompany);
echo $testArray[1];
HTH
Steve
PartyPosters wrote:
Hello,
Please can someone tell me how you pa
]]
Hello,
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many
variations of this but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
echo "";
Page2
echo $t
From: PartyPosters [mailto:[EMAIL PROTECTED]
> Hello,
> Please can someone tell me how you pass arrays between PHP pages.
> I have tried something like this and have tried many
> variations of this but
> nothing working yet ;
>
>
> Page 1
> $testArray[0] =App
[snip]
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many variations of this
but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
echo "";
Page2
echo $testArray[1];
[/s
Hello,
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many variations of this but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
echo "";
Page2
echo $testArray[1];
M
elements into an array. It may take up more storage room than
the same array would in a memory structure but this method gives you the
flexibility to store arrays of any length.
For instance, if you had the values {4,6,8,10}, {45,46,47,48}, and
{50,50,50,54} in sets 1, 2, and 3 respectively. This
* Raghudev Ramaiah
> I need this since I have around 3 sets of 20 fields each are
> of the same data type .
> if i am able to use arrays , i can say
>
> integer[20] m1;
> integer[20] m2;
> integer[20] m3;
>
> if not , i will have to declare 60 fields
> integ
Hi,
I need this since I have around 3 sets of 20 fields each are of the same data type
.
if i am able to use arrays , i can say
integer[20] m1;
integer[20] m2;
integer[20] m3;
if not , i will have to declare 60 fields
integer m1 to integr m60.
any solutions please?its quite urgent
Numeric types are simply that: numbers. They cannot be arrays.
http://dev.mysql.com/doc/mysql/en/Numeric_types.html
Incidentally, why would you need this? Maybe the group can come up with
a viable alternative for you.
Cheers,
--V
Raghudev Ramaiah wrote:
hi
i have used column types such as
hi
i have used column types such as intger and float and double for fields in the MySQL
tables. can i use arryas of integers, floats and doubles as column type? i.e., can a
field ina table be an integer array or float array ?
ex: count[20] integer is it allowed and is it an array?
thanks and re
-
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
On 1 Jun 2004, at 2:55 am, Nik Belajcic wrote:
This may be a silly question, but I am wondering if there is something
opposite to:
@row = $sth->fetchrow_array
In other words, instead of fetching rows from MySQL and loading them
into an array that can be accessed from Perl, I want to do the opposite
into $table set $sql",undef,values %record);
Richard
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Nik Belajcic" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 01, 2004 5:15 AM
Subject: Re: Perl arrays into MySQL
&
A perhaps more perlish way would be,
my $table = "MyTable";
my $sql = join ',', map {"$_=?"} keys %
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Nik Belajcic" <[EMAIL PROTECTED]>; <[EMAIL PROTECTE
Nik Belajcic wrote:
This may be a silly question, but I am wondering if there is something
opposite to:
@row = $sth->fetchrow_array
In other words, instead of fetching rows from MySQL and loading them
into an array that can be accessed from Perl, I want to do the opposite
- take a Perl (associative
This may be a silly question, but I am wondering if there is something
opposite to:
@row = $sth->fetchrow_array
In other words, instead of fetching rows from MySQL and loading them
into an array that can be accessed from Perl, I want to do the opposite
- take a Perl (associative) array and load i
On Tue, 2 Sep 2003 21:40:35 -0500
"John Macon" <[EMAIL PROTECTED]> wrote:
> I have a quick question about arrays. I know that this is probably pretty easy for
> most of you out there, so here it goes.
>
> If you remove $array[2], would $array[3] then automatic
<[EMAIL PROTECTED]>
net> cc:
John:
How do you plan to "remove" an $array[2]?
If you are using associative arrays, then you can remove an element
using the unset() function, and then the answer to your question is
"yes", so to speak:
For example:
\n";
}
$array = array( 'first'
Sorry, I forgot that would help, I am using PHP 4, pulling from a mySQL database, I am
trying to delete a record in an array before it gets written back into the table,
should I be asking this in a PHP forum instead? I should have thought of that.
I have a quick question about arrays. I know that this is probably pretty easy for
most of you out there, so here it goes.
If you remove $array[2], would $array[3] then automatically become the new $array[2]?
Thanks in advance for your help.
;To: "Hans Nerdell" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> >Subject: Re: table creation - arrays ?
> >Date: Sat, 14 Jun 2003 11:23:01 +0900
> >
> >I have read that Arrays are not coming before 5.0.
> >
> >have a look in the Documentation and the UC pr
I have read that Arrays are not coming before 5.0.
have a look in the Documentation and the UC presentations.
Best regards
NIls Valentin
Tokyo/Japan
2003年 6月 10日 火曜日 22:25、Hans Nerdell さんは書きました:
> table creation - arrays ?
>
> how are rows as ARRAYS specified and created o
Arrays are not currently supported in any production-release versions of MySQL.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Hans Nerdell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 09:25
S
table creation - arrays ?
how are rows as ARRAYS specified and created on a table ?
wbrgds
hans
_
Die aktuellsten Computer News gibts auf MSN! http://www.msn.at/computer
--
MySQL General Mailing List
For list archives: http
Hi list,
I'd like to generate arrays into a field for the result-set
by means of grouping...
myTable >> ( MySQL 3.23.33 / MyISAM table )
++--+
| id| type |
++--+
| 002 | 'CD' |
| 002 | 'LP' |
info
to another table, but the example is still accurate.)
Steve
- Original Message -
From: "Chris Comeau" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 12:06 PM
Subject: Dynamic arrays in table?
> I'm new to MySQL and i'
t;
> -Original Message-
> From: Chris Comeau [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 28, 2001 3:07 PM
> To: [EMAIL PROTECTED]
> Subject: Dynamic arrays in table?
>
>
> I'm new to MySQL and i'm having some trouble with creating a table with
> t
In addition to the purchased list, we want to have a "with list" kind of
feature where you could add and remove things you might want to buy...
So we would need to have some kind of array for each user that lists the
ids of the puchasable items, that can grow and shrink...
Any ideas?
Thanks.
I'm new to MySQL and i'm having some trouble with creating a table with
the format i need.
I need to create a table for user information (name, email, phone) and a
list of purchased items (IDs) that will grow or shrink with time, in
some kind of dynamic array.
Is it possible to have this in o
From: Philip Mak <[EMAIL PROTECTED]>
> Is there a good way that I can store an array in a single row using MySQL?
You can simply delimit the data some how. Perhaps with a pipe (|).
> I was taught that under a clean relational database design, arrays should
> be stored one
Is there a good way that I can store an array in a single row using MySQL?
I was taught that under a clean relational database design, arrays should
be stored one element per row. However, this makes retrieving the entire
array less practical, especially when I have an array of arrays.
I&#x
52 matches
Mail list logo
