[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
