How to set cascading deletion of records in MySQL?

Question

MySQL

It is necessary that when a record is deleted from a table, all records from tables related by key are automatically deleted. MySQL 5.1.61 is used. I know that it is possible to use ON DELETE CASCADE, but it does not work (a query like ALTER TABLE ... ON DELETE CASCADE is not executed due to an alleged error in the syntax, although everything is correct). Can someone write a correct working example?

Answer 1

www.mysqltutorial.org/mysql-on-delete-cascade

Answer 2

Most likely you are trying to put this option on a field that is not a link. Here is an example , the first link in Google.