我在许多表格中都有产品的数据。我想从他们的表中按产品id删除所有这些数据。但不想使用很多查询。
例如

1. delete from tbl_product_attributes where product_id = 'this'
2. delete from tbl_product_barcode where product_id = 'this'
3. delete from tbl_product_images where product_id = 'this'
4. delete from tbl_product where product_id = 'this'

我只需要一个从数据库中删除特定产品id的所有相关数据的查询。就这样

Delete data from whole DB where product_id = 'this'.

注意：而且这个查询不会对我的服务器造成负担。
有什么办法吗？