delete record in all tables without knowing all the table names

[ras68]

I have a mysql db that has approx. 60 tables. There's a main table called "Products" where all the product exists, product ids, description, etc. There are many other table such as categories, subcategories that may or may not contain data pertaining to the "Products" table.

For example, if I have a product that has a 'productid' = "1" and I want to delete the product from the database, how to I delete all the associated data in other tables if I don't know whether the data exists in the other tables?

Thanks.

[Lars_Berg]

Define foreign keys from those tables to the product table with on delete cascade.

[ras68]

Thanks Lars, but I don't want to modify any of the tables to create foreign keys as this db has an ecommerce engine that rides over top. I guess I can just do a tables_schema query and then delete records in each table if it contains the associated productid...