thanx joe, i checked. I just thought that there could be a way around this problem!
From: "Joe Stump" <[EMAIL PROTECTED]>
To: "Inandjo Taurel" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: How to write delete query??
Date: Mon, 17 Feb 2003 09:46:53 -0800
MIME-Version: 1.0
Received: from mail4.mxpath.net ([130.94.106.86]) by mc5-f9.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 17 Feb 2003 06:41:02 -0800
Received: by mail4.mxpath.net (Postfix, from userid 89)id ACE4113BA62; Mon, 17 Feb 2003 06:35:30 +0000 (GMT)
Received: (qmail 21374 invoked from network); 17 Feb 2003 06:35:28 -0000
Received: from web.mysql.com (213.136.49.183) by 130.94.106.86 with SMTP; 17 Feb 2003 06:35:28 -0000
Received: (qmail 30777 invoked by uid 7797); 17 Feb 2003 14:40:03 -0000
Received: (qmail 30759 invoked from network); 17 Feb 2003 14:40:02 -0000
X-Message-Info: dHZMQeBBv44lPE7o4B5bAg==
Delivered-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org)
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
In-Reply-To: <[EMAIL PROTECTED]>
Importance: Normal
X-MxUser: [EMAIL PROTECTED]
X-MxHost: [EMAIL PROTECTED]
X-MxDest:Maildir
Return-Path: <>
X-OriginalArrivalTime: 17 Feb 2003 14:41:03.0057 (UTC) FILETIME=[986BDC10:01C2D692]
What you have there is a subselect, which are not supported in mysql 3.2x,
but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my
word for it and check the docs first.
--Joe
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."
-----Original Message-----
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 6:35 AM
To: [EMAIL PROTECTED]
Subject: How to write delete query??
SQL SQL
hi all,
i have a query that works just fine on Dbase, but just crashes on mysql.
How can i write it in one statement for it to work both on Dbase and mysql?
the query:
- delete from table1 where table1.field1 in (select distinct field2 from
table2).
Thanx
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
