删除包含连接消息的页面的最佳方法？
我有一个用一大堆“提要项目”创建的页面 - 就像 Facebook - 我目前面临的问题是找出“删除逻辑”的最佳方法。也就是说，如果用户删除一个页面 - 我想删除此页面的“连接消息”，即：
- 提要项目
- 评论
- 等
我有许多保存提要项目、评论等的 MySQL 表 - 但我不确定如果用户删除页面，删除所有这些的最“最佳方式”？
有人可以提供建议吗？我想它类似于 StackOverflow - 如果删除问题，删除
- 问题答案
- 、
- 所有评论
等的最佳方法是什么？
I have a page that I have created with a whole bunch of 'feed items' - like facebook - the problem I am currently facing is the best way to figure out 'delete logic'. That is, if a user deletes a PAGE - I want to remove the "connected messages" to this page that is:
- feed items
- comments
- etc
I have a number of MySQL tables that hold feedItems, comments etc - but I'm unsure of the most "optimal way" to remove all this if a user deletes a page ?
Would someone be able to advise ? I guess its similar to StackOverflow - if a question is delete, what's the best way to delete
- the question
- the answers
- all the comments
etc ?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您使用 InnoDB，最简单的方法是在外键上使用
ON DELETE CASCADE。当外键引用的行被删除时，此选项使 MySQL 删除表中的行。例如，如果您有一个带有主键 ID 的表“question”，以及一个带有外键“question_id”的表“answers”，则当删除该问题时，“answers”中包含相同 Question_id 的所有行也会被删除。
否则，您需要编写多个删除语句，每个表一个。
If you're using InnoDB, the easiest way use the
ON DELETE CASCADEon you foreign keys. This option makes MySQL delete rows in tables when the row to which the foreign key refers to is deleted.For instance, if you have a table "question" with a primary key ID, and a table "answers" with a foreign key "question_id", when the question will be deleted, all the rows in "answers" that contains the same question_id will be deleted too.
Else you need to write multiple delete statements, one for each table.