Eine Einführung in

SQL

Cannot DELETE because of reference.

MySQL
If a foreign key is set up between two tables it may be that you cannot delete a record. In this case the table t_staff references the table t_dept - you cannot delete the department 'co' if a member of staff belongs to that department.
Execute set up code


Specific to MySQL
Referential integrity will be respected if the tables were created with type INNODB. This will not always be the case.