title: Deleting from a MySQL table with foreign key constraints
body: <p>I have two tables, with some data loaded in it and the two reference each other. Table B references the primary key of Table A. I manually attempt to delete some table rows from Table A that are present in Table B, and I get this:</p>
  
  <p><strong>#1451 - Cannot delete or update a parent row: a foreign key constraint fails (<code>TableA</code>.<code>TableB</code>, CONSTRAINT <code>TableB_ibfk_2</code> FOREIGN KEY (<code>column</code>) REFERENCES <code>flashcard</code> (<code>primaryKeyColumn</code>))</strong></p>
  
  <p>I am not quite sure what's up here. From what I understand,if I delete some rows of TableA then they should automatically also delete the corresponding rows present in Table B (i.e if they are present in Table B) but clearly this isn't the case here and it's prompting the above error.</p>
  
  <p>Anybody wanna whack the side of my head and let me know why ?</p>