RE: UPDATE...WHERE ... IN (SELECT...)

Hi Markus, You cannot use sub-query in mysql 3.23.49 Regards, Laercio Cavalcanti. -Original Message- From: Markus Källander [mailto:[EMAIL PROTECTED] Sent: quarta-feira, 9 de junho de 2004 13:25 To: [EMAIL PROTECTED] Subject: UPDATE...WHERE ... IN (SELECT...) Hi all, Can someone

Re: UPDATE...WHERE ... IN (SELECT...)

On Wed, 9 Jun 2004 18:25:11 +0200 Markus Källander <[EMAIL PROTECTED]> wrote: > Hi all, > > Can someone tell me what is wrong with this statement? > > UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull); > > I use MySQL 3.23.49. ^^^ 4.1 or higher is required f

RE: UPDATE...WHERE ... IN (SELECT...)

> -Original Message- > From: Markus Källander > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 09, 2004 10:25 AM > To: [EMAIL PROTECTED] > Subject: UPDATE...WHERE ... IN (SELECT...) > > > Hi all, > > Can someone tell me what is wrong with this st

RE: UPDATE...WHERE ... IN (SELECT...)

Sub-select not supported in version you are using. -Original Message- From: Markus Källander To: [EMAIL PROTECTED] Sent: 6/9/04 11:25 AM Subject: UPDATE...WHERE ... IN (SELECT...) Hi all, Can someone tell me what is wrong with this statement? UPDATE nummer SET gold = '1'

UPDATE...WHERE ... IN (SELECT...)

Hi all, Can someone tell me what is wrong with this statement? UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull); I use MySQL 3.23.49. Thanks Markus Källander