MySQL中的类型:BigInt(20)与Int(20) [英] Types in MySQL: BigInt(20) vs Int(20)
本文介绍了MySQL中的类型:BigInt(20)与Int(20)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想知道BigInt
,MediumInt
和Int
之间的区别是什么……似乎很明显,它们允许更大的数字.但是,我可以制作一个Int(20)
或一个BigInt(20)
,这看起来似乎不一定与尺寸有关.
I was wondering what the difference between BigInt
, MediumInt
, and Int
are... it would seem obvious that they would allow for larger numbers; however, I can make an Int(20)
or a BigInt(20)
and that would make seem that it is not necessarily about size.
有些见识会很棒,只是有点好奇.我已经使用 MySQL 一段时间,并试图在选择类型时满足业务需求,但是我从不理解这一方面.
Some insight would be awesome, just kind of curious. I have been using MySQL for a while and trying to apply business needs when choosing types, but I never understood this aspect.
推荐答案
查看全文