如何在我的表中存储只有两个值的属性？ [英] How do i store an attribute that has only two values in my table?

问题描述

我有一个属性'Exam'，它只能有两个值'Even'和'Odd'。

那么如何在表格中设置它？喜欢有点价值？或者像varchar？



我的尝试：



如果我使用varchar，该列只有'Even'和'Odd'值。这将导致规范化问题？

I have an attribute 'Exam' that can have only two values 'Even ' and 'Odd'.
So how do I set it in the table? like a bit value ? or like varchar?

What I have tried:

if I use varchar, then the column has only 'Even' and 'Odd' values. so that will lead to normalization issues?

推荐答案

如果你完全确定你只有两个值，那就去吧。将0视为偶数，将1视为奇数。

If you are absolutely sure that you will ever have only two values for this then go with bit. Consider 0 as even and 1 as odd.

这篇关于如何在我的表中存储只有两个值的属性？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！