Hi,
> How to store multiple values in a single field? Is there any array data
> type
> concept in mysql?
>
As Jörg said "Multiple values in a single field" would be an explicit
violation of
the relational model..."
then also, if you want to use.
this might be this will help you.
I used like this
On 14/05/2010 09:54, Joerg Bruehe wrote:
Hi Samrat, all!
Samrat Kar wrote:
Hello,
How to store multiple values in a single field? Is there any array data type
concept in mysql?
"Multiple values in a single field" would be an explicit violation of
the relational model (on which the SQL lan
Hi Samrat, all!
Samrat Kar wrote:
> Hello,
>
>
>
> How to store multiple values in a single field? Is there any array data type
> concept in mysql?
"Multiple values in a single field" would be an explicit violation of
the relational model (on which the SQL language is based) and cause all
ki
There are SETs and ENUMs, but I've always found that dealing with them is
annoying.
YMMV
/ Carsten
On Fri, 14 May 2010 13:54:29 +0530, "Samrat Kar"
wrote:
> Hello,
>
>
>
> How to store multiple values in a single field? Is there any array data
> type
> concept in mysql?
>
What is your column's type? Is it blob?
See this, might help:
http://www.phpriot.com/articles/images-in-mysql
On Tue, Apr 8, 2008 at 2:18 PM, Victor Subervi <[EMAIL PROTECTED]>
wrote:
> Hi:
> I have successfully loaded an image into my database (I believe). When I
> go
> to retrieve it, I get t
On Jan 26, 2007, at 2:33 PM, Brent Baisley wrote:
while ( $row = mysql_fetch_array($result,MYSQL_ASSOC) ) {
$this->result_List[] = $row;
}
That produces an array like this:
[0]=>
[WHAM_ID]=>15, [NAME]=>Fred, [AMOUNT]=>99
That is getting me close to what I am looking for, I just wo
oops, Sorry: I meant to post this to the PHP group.
On Jan 26, 2007, at 2:06 PM, phphelp -- kbk wrote:
Hello, folks -- lurking for a while, first post --
I'm relatively new to PHP but doing database design work for nearly
20 years.
I've RTFM'ed (+ books + other resources) a bunch of times
Nolan Rumble schrieb:
mm.. I'm not sure what you're trying to achieve here?
Why do you want an array in there? I'm pretty sure it's not possible
(correct gang?), but I'm wondering why you'd want that.
What you *can* do is just store a serialized array in a textfield.
What i'm trying to do is
On Tuesday 04 July 2006 16:21, Nolan Rumble wrote:
> SELECT COUNT(*) FROM temp GROUP BY recipient;
>
> and it will list all the email addresses and how much email they
> sent/received.
>
> I suppose I can create another table which handles the variable length
> recipients but I would like to avoid
mm.. I'm not sure what you're trying to achieve here?
Why do you want an array in there? I'm pretty sure it's not possible
(correct gang?), but I'm wondering why you'd want that.
What you *can* do is just store a serialized array in a textfield.
What i'm trying to do is dump a log file into a
Grant,
>From my old relational database days we'd create a table of courses and
index this so it could be linked from your semester table. This way, you'd
have a single entry for each course. Should the course change, the
maintenance nightmare is alleviated by only having to change the course
en
Peter Brawley wrote:
Peter Brawley wrote:
MySQL, like other relational databases, does not support arrays or
pointers.
I didn't write that.
My apologies -- it was written by John Griffin, not Peter Brawley. I
edited carelessly.
Oops.
Bruce Feist
--
MySQL General Mailing Lis
>Peter Brawley wrote:
>> MySQL, like other relational databases, does not support arrays or
>>pointers.
I didn't write that.
PB
Peter Brawley wrote:
MySQL, like other relational databases, does not support arrays or
pointers.
Of course, relational databases don't allow duplicate rows in table,
either... I have yet to find a "relational" database with that feature!
Bruce Feist
--
MySQL General Mailing List
For lis
Some intros on the web are listed at
http://www.artfulsoftware.com/dbresources.html
- Original Message -
From: John Griffin
To: Ioana ; [EMAIL PROTECTED]
Sent: Monday, June 09, 2003 10:38 AM
Subject: RE: array/pointer question
Hi,
MySQL, like other relational databases
Arrays are coming from version 5.0 as far as I know the plans.
Best regards
Nils Valentin
2003年 6月 9日 月曜日 23:49、Ioana さんは書きました:
> Hello, I have just recently started learning mysql, and was wondering if
> it supports arrays/pointers(for linked lists) of any types, and if so,
> what is the synta
Hi,
MySQL, like other relational databases, does not support arrays or pointers. Arrays
and pointers do not fit within the relational model. It would take quite a bit of text
to describe what the relational model is and how to use SQL to manipulate data. I
suggest that you read a good text on r
On Tue, 18 Jun 2002, Brad W. Galiette wrote:
> I am currently in the process of designing a database solution that requires
> columns to have array-like capabilities. To provide the group with a better
> notion of what I am trying to accomplish, please review the following
> example.
>
As far a
> Hi,
> How could I retrieve data from MySQL and put it to data array? here is
example
>
> Table Sale
> Field1 --> Date
> Field2 --> Sale Amount
> ---
> Date Sale Amount
> 1/1/2001 1000
> 1/2/2001 2000
> 1/3/2001 3000
>
>
> $data_array=array (
> array('1/1/2001',1000),
> array(
This is a PHP question and should really be asked on the PHP list.
But a suggestion. Tried using field names instead of number? ie.
$myrow["catid"];
I'd have to read up the PHP manual to find out for sure but I'm sure you can
do that just as well as I can.
- Original Message -
From: "
20 matches
Mail list logo
