关于数据库管理 [英] about database management

问题描述

如果只有两个值，如(sale，rent)(male，female)等，该如何处理数据库..最好插入bit值，例如male = true，female = false ..或sale = true，rent = false否则，第二个选项正在制作一个具有主键1,2 ..的出售和出租表，哪个更好?

if there is only two value like (sale,rent)(male,female) or etc.. what to do with database.. is it preferable to insert bit value like male=true,female=false.. or sale=true,rent=false otherwise 2nd option is making a table like for sale and rent with primary key 1,2.. which one is better?

推荐答案

只有两个值可以使用位值，但值(Sale，Rent)也可以在数据库中使用int值，您可以存储 1待售， 2待租，但是，如果有任何要求，则不会增加. (sale，rent，lease)之类的值，您可以轻松分配 3进行出租

if there is only two values you can use bit values but values like(Sale,Rent) you can also use int in your database you can store 1 for sale, 2 for rent, but if there is any kind of requirement occur to incease no. of values like(sale,rent,lease) you can easily assign 3 for lease

这篇关于关于数据库管理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！