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
Hi all,
I have positively identified the row I want to delete using:
'SELECT * FROM table LIMIT 10,1'
This has returned 1 record and I now want to DELETE the record.
How do I identify this record in my DELETE statement?
(using 'DELETE FROM table LIMIT 10,1' does not work)
NOTE : I can't
: Ross Honniball [mailto:[EMAIL PROTECTED]
Sent: Sunday, 4 April 2004 10:40 AM
To: [EMAIL PROTECTED]
Subject: Deleting records using the 'LIMIT' clause
Hi all,
I have positively identified the row I want to delete using:
'SELECT * FROM table LIMIT 10,1'
This has returned 1 record and I
-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 delete using a where clause and column values unique to
that row. Try SELECT