What is the best way to store sex in my SQL database? I am a bit confused about this issue because different people express differently. Some people recommend storing it in INT , but there are other suggestions that TINYINT and Enum , but some others suggest that they Despite this, in view of my storage in CRAR, it is more susceptible to any CHAR (1) strong> M for women and men Better idea, because it offers more robustness than ENUM? Apart from this I am concerned about scalability An important suggestion from a specialist is highly appreciated. individually (because it is some subjective question) I In addition, I did not understand What is ENUM MySQL
check does not support constraints, so actually the only way to ensure that value is
M or
F ( Or
m or
f ). For me, this is the most important point.
ENUM should only require one byte storage space (according to it), so it will only be used as efficient storage-wise
CHAR (1) or
TINYINT .
TINYINT with questions like this:
SELECT * to myTable WHERE gender = 1;
1 male or female? And if this is a man, then is woman
0 ? Or is it
2 ? Or maybe
16 ? You already have to remember a heap of writing (and retaining) an application; There is no need to add that stack.
No comments:
Post a Comment