Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Ross Honniball <[EMAIL PROTECTED]> writes:
Hi all,
I have positively identified the row I want to delete using:
'SELECT * FROM table LIMIT 10,1'
No, you didn't. Since you did not include an ORDER BY clause, MySQL
has returned the tenth row acco
the where clause!
Mike
> -Original Message-
> From: Michael Pheasant [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 4 April 2004 5:05 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Deleting records using the 'LIMIT' clause
>
>
> Hi,
>
> You need to dele
Hi,
You need to delete using a where clause and column values unique to
that row. Try "SELECT * from table limit 10,1" see if you can find some
value(s) which is unique to that record (irrelevant whether its defined
as a primary key). Eg, maybe col2 and col4 can uniquely id
The record you want t