deleting rows

[jimfog]

I want to delete 2 rows(one row in each table)-these tables are innoDB both were one column in one table references the column in the second table.

 

I know that by deleting the column in the parent table the corresponding column in the child table also gets deleted.

I assume that the delete statement will only mention the parent table-like I am deleting the row in one table and the deletion in the child table will be taken care of the storage engine.

 

But how am I going to be sure that this the case.

I have PHPMyAdmin and workbench-from where I will see that indeed this is the case?

 

 

[justsomeguy]

For triggers, you can use the SHOW TRIGGERS query to show all of the triggers. For foreign key constraints, choose a table and select and Relation View.

[jimfog]

For triggers, you can use the SHOW TRIGGERS query to show all of the triggers. For foreign key constraints, choose a table and select and Relation View.

From the above mentioned nothing achieves what I want...instead the solution is this.

DELETE ON CASCADE.