Mysql Version: 5x
DB Engine: InnoDB
I m new to Mysql
I want to delete records from multiple tables account_id being common in all as shown below.
Declare @account_id as char(4)
set @account_id= '500'
select * from promotion_products a,product_subscription_tiers b,product_features c,product_entitlement d,entitlements e,product f,contract_item g
where a.product_id=b.product_id and b.product_id=c.product_id and c.product_id=d.product_id and d.product_id=e.product_id and e.product_id=f.product_id and f.product_id=g.product_id and g.account_id=@account_id