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
