RE: How to write delete query?? - Inandjo Taurel - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRE: How to write delete query??

From	Sent On	Attachments
Inandjo Taurel	17 Feb 2003 06:34
Inandjo Taurel	17 Feb 2003 06:51
Stefan Hinz	17 Feb 2003 07:19
Bill Kratochvil	17 Feb 2003 07:21
Joe Stump	17 Feb 2003 09:46

Subject:	RE: How to write delete query??
From:	Inandjo Taurel (inan...@hotmail.com)
Date:	02/17/2003 06:51:05 AM
List:	com.mysql.lists.mysql

thanx joe, i checked. I just thought that there could be a way around this problem!

From: "Joe Stump" <jst...@aa.acinc.com>

To: "Inandjo Taurel" <inan...@hotmail.com>, <mys...@lists.mysql.com> 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: eweb...@eweb.eugene.or.us Mailing-List: contact mysq...@lists.mysql.com; run by ezmlm (http://www.ezmlm.org) List-ID: <mysql.mysql.com> Precedence: bulk List-Help: <mailto:mysq...@lists.mysql.com> List-Unsubscribe: <mailto:mysql-unsubscribe-paul.harrison=eweb...@lists.mysql.com> List-Post: <mailto:mys...@lists.mysql.com> List-Subscribe: <mailto:mysq...@lists.mysql.com> Delivered-To: mailing list mys...@lists.mysql.com Message-ID: <NLEB...@aa.acinc.com> 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: <BAY1...@hotmail.com> Importance: Normal X-MxUser: paul...@eweb.eugene.or.us X-MxHost: post...@eweb.eugene.or.us 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

-----Original Message----- From: Inandjo Taurel [mailto:inan...@hotmail.com] Sent: Monday, February 17, 2003 6:35 AM To: mys...@lists.mysql.com 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 <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jstump=aa.a...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-paul.harrison=eweb...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php