Re: Error Code: 126 - Incorrect key file. I am doubtful...
Thanks everyone for your help. I just found additional responses that I was unaware of - my apologies...
Seems this error is caused because the temp partition was running out of disk space (annoying that the error did not suggest this as the cause). I had checked the disk space, but it seems MySQL deletes the temp files when the error is thrown, so I got fooled!
Thanks again for your posts.
>> Your query looks derived from the "compare two tables" entry at
http://www.artfulsoftware.com/queries.php, is it?
Sorry Peter- don't recall where I found it...
>> you can scan one table, row by row, and search the other table for matches.
Phill - are you talking about using cursors (haven't tried that yet)?