Jump to content
Sign in to follow this  
terryds

Use foreign key delete cascade or manual ?

Recommended Posts

What's better ?

Using foreign key ON DELETE CASCADE ON UPDATE CASCADE, so it can automatically delete/update the rows.

Or...

Just manually delete it (using query) ?

 

Please tell me the pros and cons.

Share this post


Link to post
Share on other sites

This can be a logical question or a question of whether you would like to maintain history and documentation. In general you use it to automatically delete or update data that would be utterly useless garbage in the database. If you google this question you can find several discussions on this topic.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...