Thread: Need with SQL query

I need to delete a bunch of manufacturers. Can somebody help with a query to delete them knowing their ID #s?

Need to do the same with a bunch of categories.

I am using 9.3.0.0/9.3.0.0

Thanks a lot!

This will break the link between the product and the manufacturer

Code:

DELETE FROM ProductManufacturer WHERE ManufacturerID IN (1,2,3,4....,n)

And this will delete the manufacturer

Code:

DELETE FROM Manufacturer WHERE ManufacturerID IN (1,2,3,4....,n)

Or you could do the 'soft delete' which marks them as deleted, but doesn't actually delete the manufacturers from the table

Code:

UPDATE Manufacturer SET Deleted=1 WHERE ManufacturerID IN (1,2,3,4....,n)

As always, try this on a development database before doing it on your live database, if you are unsure!

Thanks a lot!