Jann Linder wrote:
> OS & PLATFORM: OH--forgot...using DBI w/perl 5 on Linux
> 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 Linder
You can do this with:
DELETE FROM tablename WHERE a='a' AND b='b' AND c='c' LIMIT 1
This only works with mysql.