Re: update from table x to table y

2001-11-14 Thread Richard Dobson
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

Re: update from table x to table y

2001-11-14 Thread Richard Dobson
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

Re: update from table x to table y

2001-11-13 Thread DL Neil
= 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]>

Re: update from table x to table y

2001-11-13 Thread Richard Dobson
-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

Re: update from table x to table y

2001-11-13 Thread DL Neil
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

Re: update from table x to table y

2001-11-13 Thread Richard Dobson
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

Re: update from table x to table y

2001-11-13 Thread DL Neil
> 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

Re: update from table x to table y

2001-11-13 Thread Heikki Tuuri
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

update from table x to table y

2001-11-13 Thread Richard Dobson
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