MAIL PROTECTED]>
>To: "Richard Dobson" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: update from table x to table y
>Date: Tue, 13 Nov 2001 21:13:19 -
>
>=No there isn't, because:
>
>7.24 UPDATE Syntax
>UPDATE [LOW_PRIORITY] [IGNORE
is because they contain things such as this along with 'nested
selects' and the such like.
T
>From: "DL Neil" <[EMAIL PROTECTED]>
>Reply-To: "DL Neil" <[EMAIL PROTECTED]>
>To: "Richard Dobson" <[EMAIL PROTECTED]>, <[EMAIL PROTEC
= 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]>
-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 -
>
>Duplicating values (cf keys) in tables involves de-normalisati
ich
>
> >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, 1
il" <[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 -
>
> > Hi does anyone know of a way of taking some data from one table and
&g
> 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_Referen
Rich,
>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!
>thanks
>
>Rich
Sinisa is right now writing a multi-table update to 4.0. Some updates can be
handled alread
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!
thanks
Rich
_
Get your FREE download of MSN Explor