posted 17 years ago
I inherited the maintenance of a monolithic web application with a MySQL 4.1 backend.
I am trying to clean out orphaned records (which are counted in the thousands, unfortunately).
I've been able to determine exactly which records should go using the following type of statement:
However, I haven't been able to construct any DELETE statements that my database will process.
I've tried:
Since google says that MySQL 4.1 doesn't support deleting with a subquery that selects from the same table as you are deleting from, I also tried:
In both cases, the error message says I have a syntax error at the location where my subquery starts.
Any suggestions as to what I can try next?
Katrina
[ January 13, 2008: Message edited by: Katrina Owen ]