Re: Deleting records using the 'LIMIT' clause

2004-04-04 Thread Michael Stassen
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

RE: Deleting records using the 'LIMIT' clause

2004-04-03 Thread Michael Pheasant
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

RE: Deleting records using the 'LIMIT' clause

2004-04-03 Thread Michael Pheasant
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