Re: find duplicates - revisted

2005-04-20 Thread doug
Yes - thanks. I did not define the data with keys because it does not come out of the source that way. Keys and replace does it nicely. Probably my question defined me as a newbie, if not well... Thank you very much for you help. On Wed, 20 Apr 2005, Duncan Hill wrote: > On Wednesday 20 April 2

Re: find duplicates - revisted

2005-04-20 Thread Duncan Hill
On Wednesday 20 April 2005 16:55, [EMAIL PROTECTED] typed: > For the small number of records, this query takes a remarkable amount of > time, so clearly this solution does not scale. A query that uses keys should not take a long time to run - unless your key data is not maintained as a key in the

find duplicates - revisted

2005-04-20 Thread doug
I have read the MySQL Cookbook and the last 6 months (or so) of threads on this. I have a slightly different problem. I use a billing system implemented in filemaker. Happily they are going a rewrite in MySQL/PHP, but for the present I maintain a MySQL database so I can track things otherwise not a