Using MySql. I can make this from another language iteranting for each one
of the elements in the table, but in this form it is really very slow,
because the real table is too big,. for that reason I would like to know if
it is possible to make this using only MySql instructions.

Sorry for my english,

Javier

----- Original Message -----
From: Jeremy Zawodny <[EMAIL PROTECTED]>
To: Javier <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, October 28, 2001 5:13 AM
Subject: Re: How I can do this


> On Fri, Oct 26, 2001 at 10:04:44AM +0100, Javier wrote:
> > Hi,
> >
> > I need do the follow:
> >
> > Table 1.
> > Field 1. Varchar (6)
> > Field 2. Varchar (6)
> >
> > The data in this table are for example
> >
> > Field 1                 Field 2
> >  A                           TT
> >  A                           YY
> >  A                           RR
> >  B                           FF
> >  B                           KK
> >
> > I need to obtain a result in the following form:
> >
> > A      TTYYRR
> > B      FFKK
> >
> > How can i do this?
>
> Using what programming language?
>
> > This message has been scanned for all known viruses by
> > MessageLabs. This message is intended for the stated recipients only
> > and may be confidential. Opinions expressed in this email do not
> > necessarily reflect the opinions of Globepost Travel or
> > Travelselect.com. If you feel you received this email in error and
> > would not like receive any further emails from travelselect.com,
> > please reply to [EMAIL PROTECTED] ***
>
> So if I send an unsubscribe message, will you no longer mail me?  That
> seems strange unless you're some kind of smart spam bot.  Are you?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 52 days, processed 1,160,921,191 queries (258/sec.
avg)
>
> *** This message has been virus scanned by Messagelabs ***


*** This message has been scanned for all known viruses by MessageLabs. This message 
is intended for the stated recipients only and may be confidential. Opinions expressed 
in this email do not necessarily reflect the opinions of Globepost Travel or 
Travelselect.com. If you feel you received this email in error and would not like 
receive any further emails from travelselect.com, please reply to 
[EMAIL PROTECTED] ***

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to