From: Abhi <[EMAIL PROTECTED]> > Could you pls let me know how to delete duplicate records in a table?=20
DELETE FROM my_table WHERE [predicate] LIMIT 1; --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql --------------------------------------------------------------------- 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