Help with database problem.

[chalfontgifts]

I Have a problem with an import routine I have setup for my products.

For some reason it has placed lots of empty rows in the products_description table and products_to_categories table.

Before I investigate this I need to delete the empty rows.

Can someone help me with the code required to do this, as nothing I have tried so far seems to work.

This is what I want to do.

Find all the records in the products_description table with a blank products_description feild. Pickup the product id. Delete the row with that product ID in the products_to_categories table and delete it. Then delete the blank row with same id in the products_description table.

I have tried this with mysql and mysql administrator, but there are so many rows it just locks up. 848000 rows to be exact.

Regards
Laurie

[kobra]

How did you inject that many empty rows?

Did you not backup before doing this?