Careful! I should clarify ... before you do the delete, make sure the columns really do uniquely identify that row with
> select * from table where col2='some value' and col4='some other value' ...without the limit clause. Delete will delete everything that matches 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 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/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
