thank you
Steve Meyers wrote:
>That will be in some release of either 4.0 or 4.1, I'm not sure which.
>=20
>Steve Meyers
>
>
>> -Original Message-
>> From: JohnHomer [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, October 19, 2001 2:11 AM
>> To:
JohnHomer wrote:
> can mysql allow table joins when using UPDATE query? like
The manual answers these questions.
> update tranfer left join transferdetails
> on transfer.docno = transferdetails.docno
> set transferdetails.docno = concat('SJ',transferdetails.DocNo)
> where
> transferdetails.docn
That will be in some release of either 4.0 or 4.1, I'm not sure which.
Steve Meyers
> -Original Message-
> From: JohnHomer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 2:11 AM
> To: [EMAIL PROTECTED]
> Subject: join tables on UPDATE
>
>
>
hi list,
can mysql allow table joins when using UPDATE query? like
update tranfer left join transferdetails
on transfer.docno = transferdetails.docno
set transferdetails.docno = concat('SJ',transferdetails.DocNo)
where
transferdetails.docno not regexp '^SJ' and
lower(xfrom) = 'san juan';
i get
