Could you pls suggest me why this query is not working. I have to
delete all duplicate records from me table. here sno is auto increment
and domain is table field.
1.DELETE FROM tbl_raw_whois_lookup WHERE domain = '007X.COM' ORDER BY
sno LIMIT 1;
coulsd you pls send my a sql query for
Could you pls let me know how to delete duplicate records in a table?
Pls send SQL query.
Thanks!
Abhi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
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