Hi Ralf,
In reading your note I'm trying to understand why you are attempting to do
what you are explaining. Why not make the 'Description' field big enough to
hold the entire description? If space is a concern, maybe using a VARCHAR
field?
If I'm missing something, please fill me in.
Have a great day...
John
"Ralf R. Kotowski" wrote:
> Hi,
>
> I have here a data set that is broken down in 4 columns, the first
> one is a code, the second is the ID, 3rd someones name, 4th a
> description.
>
> the problem: the description filed is broken down in some cases
> over several rows, taking the place of the name field, in this case
> the code field changes to indicate that its a continuation from the
> row above, ID filed is identical, looks kinda like this.
>
> ________________________________
> | A | 0003 | Joe Doe | Description |
> | A | 0004 | Jane Doe| Description |
> | L | 0004 | Description of Jane doe |
> | A | 0005 | some else | Description |
> ---------------------------------------------------------
>
> in some cases the "Description" Field can spread over 4 rows, 1
> "A" and 3 "L"'s. Since it shifts one field I have absolutely no clue on
> how to get all the apropiate descriptions into a single field.
>
> I'm awake now for around 72 hours... so please excuse if my
> grammar, spelling.. reasoning ain't to clear.
>
> Thanx for any pointers...
>
> Ralf
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail mysql-thread58198@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-john=greengator.com@stripped>
>
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
