Hi Ralf, yes, but which one? I expressed it poorly. Without a PK, you cannot delete a SPECIFIC record. I'm unclear how even a FE using ODBC would be able to identify and delete a specific record in these conditions. Unlike FoxPro and (UGH) Access, MySql does not (to the best of my knowledge) maintain an internal record number for each record. Therefore when you issue the delete statement below, and it finds more than 1 record, you cannot pre-determine which one it will delete.
I don't do much with MySQL via ODBC and can't remember the last time I created a table without a PK, but my working theory is that if he's using a Win-based FE, accessing through ODBC and issuing an ambiguous delete (i.e. browsing the table in access and deleting a specific record) This MAY be the problem. As I said, I've not tested it so I could be off in left field. :) =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * ----- Original Message ----- From: "Ralf Narozny" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Nick Traenkner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 12:05 PM Subject: Re: delete corrupts > > > [EMAIL PROTECTED] wrote: > > >What version of MySQL? > >What interface are you using to execute the delete? > > > >How do you know you only deleted one of the records? From a CLI, without a > >PK, there would be no way to delete only one. Delete from Works where title > >= something would delete both of them. > > > > > > delete from <table> where <expression> limit 1; > > would only delete one of the rows at least in 3.23.40+ it does :) > > -- > Ralf Narozny > Splendid Internet GmbH > Skandinaviendamm 212, 24109 Kiel, Germany > fon: +49 431 660 97 0, fax: +49 431 660 97 20 > mailto:[EMAIL PROTECTED], http://www.splendid.de > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php