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 to nuke so you can then do:
> delete from table where col2='some value' and col4='some other value' The order of rows is undefined unless you use an order by clause. I don't know if there is a way to delete the '11th' record as determined by select. Cheers, M > -----Original Message----- > From: 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 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 identify it using it's key fields as the table has no > primary key. > > Help greatly appreciated. > > Regards ... Ross > > . Ross Honniball JCU Bookshop Cairns Supervisor > . James Cook Uni, McGreggor Rd, Smithfield, Qld. 4878, Australia > . Ph:07.4042.1157 Fx:07.4042.1158 Em:[EMAIL PROTECTED] > . There are no problems. Only solutions. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
