From: Thimble Smith
Date: March 12 1999 3:42pm
Subject: Re: Delete the first found record in SQL?
List-Archive: http://lists.mysql.com/mysql/90
Message-Id: <19990312084216.C28088@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

One way to do it (maybe not the best) is to create a temporary table
just like tablename, SELECT DISTINCT into that table (or do whatever
you need in order to get the info you want into that table - select
limit 1, whatever), then drop the first table and rename.  There are
several variations on this scheme that might work for you.

By the way, MySQL doesn't support SELECT ... INTO TABLE ...; but it
does support INSERT INTO TABLE foo (f, g, h) SELECT x, y, z FROM ...,
which is usually just as good.

Tim


On Thu, Mar 11, 1999 at 07:44:22PM -0800, Jann Linder wrote:
> I have a table with 3 fields.
> 
> I have many records with IDENTICAL Fields.
> 
> I want to pass the following:
> 
> delete from tablename where a='a' and b='b' and c='c'
> 
> and have the MySQL remove the FIRST RECORD ONLY where this criteria is met.
> 
> How is this possible?
> 
> HLP ASAP!
> Jann
> 
> --
> Jann Linder
> Web Developer
> Perl Programmer
> 
> Personal Site: http://www.jann.com/
> CalendarPlus Site: http://www.calendarplus.com/
> 
> 
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread66@stripped
> 
> To unsubscribe, e-mail the address in the List-Unsubscribe header.
> For additional commands, e-mail: mysql-help@stripped
>