Thanks...

Currently I am doing exactly that.  One data set open creating another.  I
was trying to speed the process up, although I am only dealing with 20,000
records so shouldn't complain.  Thanks all for the suggestions...  I look
forward to 4.x

JJ

----- Original Message -----
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED] Mysql. Com" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 10:14 AM
Subject: RE: UPDATE syntax help


> Paul,
>
> You have to use the results of one select to generate lots of update
> statements.  If you execute all these from your program, make sure you use
a
> different database connection for the updates, if you're keeping a results
> set open.
>
> Alternatively, if it's a one off, generate a script file with your code
(or
> directly from SQL if you're a martyr) and then run it.
>
> I've used both methods successfully,
>
> Andy
>
> > -----Original Message-----
> > From: JJ [mailto:[EMAIL PROTECTED]
> > Sent: 12 March 2003 23:45
> > To: MySQL
> > Cc: Paul DuBois
> > Subject: Re: UPDATE syntax help
> >
> >
> > That explains it then.... D'OH
> > Is there a workaround?
> > Thanks :-)
> >
> > ----- Original Message -----
> > From: "Paul DuBois" <[EMAIL PROTECTED]>
> > To: "MySQL" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 13, 2003 9:02 AM
> > Subject: Re: UPDATE syntax help
> >
> >
> > > At 8:33 +1000 3/13/03, MySQL wrote:
> > > >Hi all,  I am having a little UPDATE syntax issue.  According to the
> > manual
> > >
> > > According to the manual, this won't work until MySQL 4.x
> > >
> > > >
> > > >UPDATE EBA_USERS, IMPORT_USERS
> > > >SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID,
> > > >EBA_USERS.REP_LOCATION_ID = IMPORT_USERS.REP_LOCATION_ID,
> > > >EBA_USERS.REP_FIRST_NAME = IMPORT_USERS.REP_FIRST_NAME,
> > > >EBA_USERS.REP_LAST_NAME = IMPORT_USERS.REP_LAST_NAME,
> > > >EBA_USERS.REP_DISABLED = IMPORT_USERS.REP_DISABLED
> > > >WHERE EBA_USERS.REP_ID = IMPORT_USERS.REP_ID
> > > >
> > > >should work (as I understand it ;-)  but I get the error
> > > >
> > > >ERROR 1064: You have an error in your SQL syntax near ' IMPORT_USERS
> > > >SET EBA_USERS.HUB_ID = IIMPORT_USERS.HUB_ID,
> > EBA_USERS.REP_LOCATION_ID =
> > > >IMPO' at line 1
> > > >
> > > >I did note in the comments section at the bottom someone else with
> > > >same/similar problem, but have been unable to find a thread in the
mail
> > > >archive.  My apologies if this has been dealt with already, or a
> > workaround
> > > >suggested...
> > > >
> > > >MySQL 3.23.51-nt on a Win2K box
> > > >MyODBC 3.51
> > > >
> > > >Thanks
> > > >
> > > >Jeff Creed
> > > >Throbware
> > > >
> > > >(0417) 797 592
> > > >http://www.throbware.com.au
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > 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
>


---------------------------------------------------------------------
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