2 messages in com.mysql.lists.mysqlRe: Delete sql statement
FromSent OnAttachments
Abhi20 Sep 2002 15:11 
Rodney Broom20 Sep 2002 15:55 
Subject:Re: Delete sql statement
From:Rodney Broom (rbr@rbroom.com)
Date:09/20/2002 03:55:53 PM
List:com.mysql.lists.mysql

From: Abhi <ab@domainsystems.com>

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