Hi,
My opinion:
If you design your DataBase in correspondence with Boyce-Codd rules i think
you can avoid all this complications.
Good luck,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Alexander Shaw" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, May 18, 2002 12:53 PM
Subject: RE: [Fwd: Add existing related data to a table]
> Thanks for this response, it is one way round the problem but is going to
> require copying the tables, some of them very large a number of times over
> and over. Is their no way of simply adding the data alongside the existing
> columns?
>
> Alex
>
> ----------------------------------------------
>
> Alexander Shaw
> Agricultural Stock and Assignment Photography
>
>
>
> > -----Original Message-----
> > From: Sabine Richter [mailto:[EMAIL PROTECTED]]
> > Sent: 17 May 2002 23:12
> > To: [EMAIL PROTECTED]
> > Subject: [Fwd: Add existing related data to a table]
> >
> >
> > Sorry,
> > I've been too long in a list where you just answer the questioner and
> > then the questioner writes a summary of the answers to the list.
> > Sabine
> >
> > Sabine Richter wrote:
> > >
> > > Hello Alexander,
> > >
> > > your problem is near to Taylor Lewick's and I have a similar
suggestion
> > > for you:
> > >
> > > 1) create newtab
> > > select tableA.*, tableB.SubcatID
> > > from tableA.*, tableB
> > > where ...
> > > 2) delete tablea
> > > 3) rename table newtab to tablea
> > >
> > > If there are more rows in tableB (1:n), you don't loose data. The data
> > > of tabA
> > > will be dublicated.
> > >
> > > Ok, that are 3 statements.
> > >
> > > Bye
> > > Sabine
> > >
> > > Alexander Shaw wrote:
> > > >
> > > > Hi,
> > > >
> > > > I'm looking for some suggestions of making a one time update
> > to some of my
> > > > tables to make them useable with new forms and queries I'm
> > creating. I have
> > > > a series of tables which hold related data and only the last
> > part of the
> > > > data is stored in a final table, which means to search data based on
> > > >
> > > > some of the information higher up the table structure is
> > making some very
> > > > complex and dodgy queries.
> > > >
> > > > I want to insert the related data into the final table but
> > can't think of a
> > > > way of doing it. The example below might help me explain
> > better what I mean.
> > > >
> > > > Consider two tables - TableA which contains PicID and KeywordID
> > > >
> > > > TableB which contains
> > SubcatID and KeywordID
> > > >
> > > > What I want to do is insert the corresponding values for relating to
> > > > KeywordID for SubCatID into a new column in TableA.
> > > >
> > > > Any suggestions how to work this to add the extra information
> > to existing
> > > > records?
> > > >
> > > > Alex
> > > >
> > > > ----------------------------------------------
> > > >
> > > > Alexander Shaw
> > > > Agricultural Stock and Assignment Photography
> > > >
> > > > p.s. to get throught he spam trap - sql query
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002
> > > >
> > >
> ---------------------------------------------------------------------
> > > > 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
> >
> > ---------------------------------------------------------------------
> > 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
> >
> > ---
> > Incoming mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002
> >
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
