RE: UPDATE syntax help

2003-03-23 Thread Doug Thompson
table. > >Regards, > >Sal > > >> -Original Message- >> From: MySQL [mailto:[EMAIL PROTECTED] >> Sent: 12 March 2003 22:33 >> To: MySQL >> Subject: UPDATE syntax help >> >> >> Hi all, I am having a little UPDATE synt

RE: UPDATE syntax help

2003-03-22 Thread [EMAIL PROTECTED]
Hi I may be way off base here but - why do you reference IMPORT_USERS in your UPDATE statement? You aren't updating any columns in that table. Regards, Sal > -Original Message- > From: MySQL [mailto:[EMAIL PROTECTED] > Sent: 12 March 2003 22:33 > To: MySQL > Su

Re: UPDATE syntax help

2003-03-12 Thread JJ
"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.

RE: UPDATE syntax help

2003-03-12 Thread Andy Eastham
cript 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: UPD

Re: UPDATE syntax help

2003-03-12 Thread Paul DuBois
s" <[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 th

Re: UPDATE syntax help

2003-03-12 Thread JJ
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 Subj

Re: UPDATE syntax help

2003-03-12 Thread Paul DuBois
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_

UPDATE syntax help

2003-03-12 Thread MySQL
Hi all, I am having a little UPDATE syntax issue. According to the manual 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_