does mysql support array datatype now?

On Tue, 25 Dec 2007 21:37:52 -0800 (PST), jo3c wrote:
> does mysql support array datatype now?

It doesn't HAVE one. What do you want to accomplish?

--
50. My main computers will have their own special operating system that will
be completely incompatible with standard IBM and Macintosh powerbooks.
--Peter Anspach's list of things to do as an Evil Overlord

On Dec 26, 10:03 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On Tue, 25 Dec 2007 21:37:52 -0800 (PST), jo3c wrote:
> > does mysql support array datatype now?
>
> It doesn't HAVE one. What do you want to accomplish?
>
> --
> 50. My main computers will have their own special operating system that will
> be completely incompatible with standard IBM and Macintosh powerbooks.
> --Peter Anspach's list of things to do as an Evil Overlord

array datatype structure for array data qurey

On Wed, 26 Dec 2007 20:47:32 -0800 (PST), jo3c wrote:
> On Dec 26, 10:03 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
>> On Tue, 25 Dec 2007 21:37:52 -0800 (PST), jo3c wrote:
>> > does mysql support array datatype now?
>>
>> It doesn't HAVE one. What do you want to accomplish?
>>
>> --
>> 50. My main computers will have their own special operating system that will
>> be completely incompatible with standard IBM and Macintosh powerbooks.
>> --Peter Anspach's list of things to do as an Evil Overlord
>
> array datatype structure for array data qurey

It doesn't HAVE one. What do you want to accomplish?

--
The Write Many, Read Never drive. For those people that don't know
their system has a /dev/null already.
-- Rik Steenwinkel, singing the praises of 8mm Exabytes

On Dec 26, 5:37 am, jo3c <JO3chi...@gmail.com> wrote:
> does mysql support array datatype now?

As has been said MySQL has no datatype for storing arrays however
there are multiple ways to get around this depending on the language
you are using with it and what you wish to do with the array.
If you let us know I'm sure someone can ...repeating the same
thing isn't going to solve much.

On Dec 28, 6:14 am, Adam Gibbins <adamgibb...@gmail.com> wrote:
> On Dec 26, 5:37 am, jo3c <JO3chi...@gmail.com> wrote:
>
> > does mysql support array datatype now?
>
> As has been said MySQL has no datatype for storing arrays however
> there are multiple ways to get around this depending on the language
> you are using with it and what you wish to do with the array.
> If you let us know I'm sure someone can ...repeating the same
> thing isn't going to solve much.

sorry, i am a newbie to the company.

so i can't really exactly tell u what/ why we need array datatype
structured database, but we need it XD

basically we got a bunch of raw data from some scanner machine.. it's
got:
header: list of info. batch, date, machine, setting values etc
attributes: and values;

so if there is anything to be able to go around it in mysql would be
greatly!
coz i don't wanna learn postgres XD

jo3c wrote:
> On Dec 28, 6:14 am, Adam Gibbins <adamgibb...@gmail.com> wrote:
>> On Dec 26, 5:37 am, jo3c <JO3chi...@gmail.com> wrote:
>>
>> > does mysql support array datatype now?
>>
>> As has been said MySQL has no datatype for storing arrays however
>> there are multiple ways to get around this depending on the language
>> you are using with it and what you wish to do with the array.
>> If you let us know I'm sure someone can ...repeating the same
>> thing isn't going to solve much.
>
> sorry, i am a newbie to the company.
>
> so i can't really exactly tell u what/ why we need array datatype
> structured database, but we need it XD
What does XD mean?
If you don't know "why" you need an array datatype, how do you know that you
"do" need one.

> basically we got a bunch of raw data from some scanner machine.. it's
> got:
> header: list of info. batch, date, machine, setting values etc
> attributes: and values;
If you're going to do anything serious with this data, then hold your
"arrays" as proper normalised data ins relationaly tables.

> so if there is anything to be able to go around it in mysql would be
> greatly!
Yep, normalised data.

> coz i don't wanna learn postgres XD
I'd still advise you to normalise it even in postgres!

jo3c wrote:
> On Dec 28, 6:14 am, Adam Gibbins <adamgibb...@gmail.com> wrote:
>> On Dec 26, 5:37 am, jo3c <JO3chi...@gmail.com> wrote:
>>
>>> does mysql support array datatype now?
>> As has been said MySQL has no datatype for storing arrays however
>> there are multiple ways to get around this depending on the language
>> you are using with it and what you wish to do with the array.
>> If you let us know I'm sure someone can ...repeating the same
>> thing isn't going to solve much.
>
> sorry, i am a newbie to the company.
>
> so i can't really exactly tell u what/ why we need array datatype
> structured database, but we need it XD
>
> basically we got a bunch of raw data from some scanner machine.. it's
> got:
> header: list of info. batch, date, machine, setting values etc
> attributes: and values;
>
> so if there is anything to be able to go around it in mysql would be
> greatly!
> coz i don't wanna learn postgres XD

You're not explaining how you need to use this data. Why does all
that info have to be stored in one field? How big can that data be?
Maybe a better description of the above data would because all
you've done is describe a basic database table structure.

--
Norman
Registered Linux user #461062