Sorry, I meant to send this reply to the whole mailing list, not just to
Shawn.
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 14, 2004 2:18 PM
Subject: Re: update/join question..
> Okay, I st
Spruce Pine
"Rhino" <[EMAIL PROTECTED]> wrote on 09/14/2004 01:24:19 PM:
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 14, 2004 11:45 AM
Subject: update/join question..
> hi...
>
> a
Original Message -
> From: "bruce" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 14, 2004 11:45 AM
> Subject: update/join question..
>
>
> > hi...
> >
> > a question on how to do an update on a table that depen
Original Message -
> From: "bruce" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 14, 2004 11:45 AM
> Subject: update/join question..
>
>
> > hi...
> >
> > a question on how to do an update on a table that depen
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 14, 2004 11:45 AM
Subject: update/join question..
> hi...
>
> a question on how to do an update on a table that depends on 'left/right'
&g
hi...
a question on how to do an update on a table that depends on 'left/right'
joins with other tables...
i have the following select that works.
select
u1.urltype as type,
p1.fileID as fileID,
l1.process as process,
l1.status as status
from university_urlTBL as u1
right join parsefileTBL as p1
>
> what i want is:
>
> UPDATE users SET userinfo_set=1 where (users.userid=userinfo.userid);
>
> aka, i want to set a flag in every row in users if there is a row
> in userinfo with the same userid.
>
> i've been SELECT INTO OUTFILEing (with a join on the two tables)
> and LOAD DATA INFILEi
i feel like i must be missing something simple because i keep wanting to do things
like this, but i can't find a one step way to do
it.
whether or not there is an easy way, can someone tell me the best way to do it?
i want to update a field in one table based on data in another table.
example: