terryds Posted August 24, 2014 Share Posted August 24, 2014 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. Link to comment Share on other sites More sharing options...
davej Posted August 24, 2014 Share Posted August 24, 2014 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now