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