Re: subquery in delete

Hiho hiho! BORUSKUNG wrote: >Hi all, > >I have a SQL question. >If I want to delete all the duplicated record in a table, >how can I do that in MySQL? >I am using MySQL 3.23.49 on AIX 4.3.3 > >there is a key field in the table > >what I want to do is check all the duplicated record by >select or

subquery in delete

Hi all, I have a SQL question. If I want to delete all the duplicated record in a table, how can I do that in MySQL? I am using MySQL 3.23.49 on AIX 4.3.3 there is a key field in the table what I want to do is check all the duplicated record by select order_no, count(*) from order group by orde