#1451: Cannot delete or update a parent row: a foreign key constraints fails

ALTER TABLE `user_credentials` ADD CONSTRAINT `user_credentials_ibfk_1` FOREIGN KEY (`id`) REFERENCES `admin`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

Thank you very much Sir ❤ muze yehi error pareshan kr rha tha

the fuck is this language

Thank you so much , i didn't even see the rest of video i just firgured out u could change the drop action to cascade , i am like yep this is it

Спасибо!

Thank You so much. It's very helpful!

thank you so much!!!!!

Thank you so much. Today I resolve my issue

thank you man you are worder

Do I have to make the table on delete cascade? I would like to mannually delete corresponding rows in child table and then delete parent table entry. Is it possible.

Btw I am using postgres.
My table is like this
user table:- id, userName,password
TodoTable :- todo_id,title,description, user_id

user_id in TodoTable references id of users table.

I want to delete a particular user from users table.

thanks

Thanks man!

thanks you sir

Thank you sir.

Thank youuu 💪

Thank you so much👍

thanks bhai

roses are red violets are blue, the title is in english so why arent you?

👍