MySQL中许多布尔值的替代方案? [英] Alternative to lots of booleans in MySQL?

问题描述

假设我有一个复选框搜索表单，如下所示:

let's say I have a checkbox search form like this:

检查您感兴趣的所有内容:

• 保龄球
• 台球
• 甜食

我可以从数据库中请求此数据，而不必像这样向数据库中添加大量布尔值吗?

Can I request this data from a database instead of having to resort adding tons of booleans to a database such as this?

(地点ID，IfBowling，IfBilliard，IfSweets)

(VenueId, IfBowling, IfBilliard, IfSweets)

也许只有一列包含场所本身具有的所有这些选项?

And maybe just have one column that would contain all of those options that the venue itself has?

推荐答案

替代..确定..容易:

Alternative .. sure .. easy :

User表，Interests表，UserInterests表.

UserInterests用于存储Users和Interests之间的多对多关系，并且包含上述表中FOREGN KEY的值.

UserInterests is used to store many-to-many relation between Users and Interests, and contains values which are FOREGN KEYs from said tables.

P.S.您确实应该阅读 SQL Antipatterns 这本书.您将从中学到很多东西.

P.S. You really should read SQL Antipatterns book. You would learn a lot from it.

这篇关于MySQL中许多布尔值的替代方案?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！