Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
November 2, 2005, 3:57 am
rate this thread
Re: Deleting multiple rows that have the same field value.
Have you tried:
delete from table where table.field = 'XYZ' limit 10;
This is one of the reasons why a field:
id int not null auto_increment primary key
is useful. It guarantees you will be able to generate a query to just
delete what you want to delete.
Gordon L. Burditt
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum