Hi, thanks dn,
so, to confirm, there is no MySQL to represent the following?:
update Raw,Unresolved_Duplicates_perm set Raw.Inactivate = 1 where
Raw.Key_num = Unresolved_Duplicates_perm.MinOfKey
and Raw.Peak1=0
Thanks
Rich
>From: "DL Neil" <[EMAIL PROTECTED]>
>Reply-To: "DL Neil" <[EMAIL PROTECTED]>
>To: "Richard Dobson" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: update from table x to table y
>Date: Tue, 13 Nov 2001 13:49:23 -0000
>
>Duplicating values (cf keys) in tables involves de-normalisation and is
>therefore not recommended.
>
>Your observation row cf column is correct. I felt the question was
>sufficiently broad to risk interpreting
>"update" as wider than "UPDATE", sorry - the other response seemed to hit
>that nail on the head (have deleted
>it).
>
>If it doesn't suit, then another solution might be to use PHP to SELECT the
>data from table1 and then use a
>second query to UPDATE table-2 SET table2-col = table1-col WHERE table1-val
>= table2-val (which, in its present
>form, has the potential to modify numerous rows in one hit).
>
>=Regards,
>=dn
>
>
> > thanks for that, but that will add a row as opposed to updating a column
> > won't it?
> > I don't want to insert a new row.
> > All I want to do is update a value in table1 if it is present in table2
> >
> > cheers
> > Rich
> >
> > >From: "DL Neil" <[EMAIL PROTECTED]>
> > >Reply-To: "DL Neil" <[EMAIL PROTECTED]>
> > >To: "Richard Dobson" <[EMAIL PROTECTED]>,
><[EMAIL PROTECTED]>
> > >Subject: Re: update from table x to table y
> > >Date: Tue, 13 Nov 2001 11:45:45 -0000
> > >
> > > > Hi does anyone know of a way of taking some data from one table and
> > >updating
> > > > another table with it?
> > > >
> > > > If MySQL doesn't support it i'm gonna have to go back to Access or
> > > > something!
> > >
> > >
> > >Rich
> > >
> > >=only "go back" to Access if you're a glutton for punishment!
> > >
> > >=try MySQL/HTMLmanual/manual_Reference.html#INSERT_SELECT
> > >
> > >=dn
> > >
> > >
> > >
> > >---------------------------------------------------------------------
> > >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
> > >
> >
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
> >
> >
>
>
>---------------------------------------------------------------------
>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
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
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
