title: How to delete automatically all reference rows if parent row get deleted in mysql?
body: <p>I have a database which contains around 50 tables.</p>
  
  <p>Suppose I have a table named parent with id primary key and 24 approx child tables with reference to this parent table.</p>
  
  <p>I haven't used on delete cascade.
  I have already searched about doing joins can perform delete in all child table. But join on 20-30 tables? Its too much.</p>
  
  <p>Please let me know is there any other solution to delete all this child rows if parent get deleted.</p>