Hi everyone.
Guys i have 2 tables in a mysql database that im using with php.
They are called
projects_pro and
currenttasks_ctk
In projects_pro, i simply have 2 fields, namely:
id_pro (auto_increment) and
name_pro ( a unique name for the project)
In currenttasks_ctk, i have the following fields...
id_ctk (auto_increment)
name_ctk
fk_id_pro_ctk ( foreign key to the id_pro field of the projects_pro table)
description_ctk
So basically, in order to add a new task to the currenttasks_ctk table, the new task MUST have a reference to the id_pro field for the column fk_id_pro_ctk, otherwise the new record is rejected.
The problem im having is this...
I cannot delete a project record from the projects_pro table IF there exists any records with this id value (eg. for fk_id_pro_ctk) in the currenttasks_ctk table.
So im wondering how i can remove a record from the projects_pro table, and 'cascade' or delete all corresponding entries that have this id_pro value for fk_id_pro_ctk ?
Basically, if i remove a project, and it has attached to it, tasks in the currenttasks_ctk table, I need those tasks deleted from the currenttasks_ctk table upon choosing to remove that project.
At the moment, i cant remove project records, and im using the following for example.
delete from projects_pro where id_pro = '10';
The error i get is:
Cannot delete or update a parent row: a foreign key constraint fails (`tasksdb/currenttasks_ctk
`, CONSTRAINT `currenttasks_ctk_ibfk_1` FOREIGN KEY (`fk_id_pro_ctk`) REFERENCES `projects_pro` (`id_pro`))
Any help greatly appreciated.
Start Free Trial
