5 messages in com.mysql.lists.mysqlRE: UPDATE...WHERE ... IN (SELECT...)
FromSent OnAttachments
Markus Källander09 Jun 2004 09:24 
Victor Pendleton09 Jun 2004 09:28 
Young, Michael09 Jun 2004 09:32 
Josh Trutwin09 Jun 2004 09:34 
Laercio Xisto Braga Cavalcanti09 Jun 2004 12:50 
Subject:RE: UPDATE...WHERE ... IN (SELECT...)
From:Young, Michael (mich@transcore.com)
Date:06/09/2004 09:32:19 AM
List:com.mysql.lists.mysql

-----Original Message----- From: Markus Källander [mailto:mark@scandinavianbilling.com] Sent: Wednesday, June 09, 2004 10:25 AM To: mys@lists.mysql.com Subject: 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

Sub-queries aren't supported in your version of MySQL. I believe you must have
version >= 4.1 for that to work.

-- Michael