MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jann Linder Date:March 12 1999 3:44am
Subject:Delete the first found record in SQL?
View as plain text  
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?


Jann Linder
Web Developer
Perl Programmer

Personal Site:
CalendarPlus Site:

Delete the first found record in SQL?Jann Linder12 Mar
  • Re: Delete the first found record in SQL?Thimble Smith12 Mar