开发者

What is the limit of the field type BIGINT in SQL?

What is the limit of the field type BIGINT in SQL?

is 100000235882380 or 100000466411115 acceptable? (That is ID from f开发者_运维问答acebook)


Check the manual of the RDBMS you're using. It may not be the same in all systems.

MySQL:
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html

PostgreSQL:
https://www.postgresql.org/docs/10/static/datatype-numeric.html

SQL Server (Transact-SQL):
https://learn.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql

DB2:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_biginteger.htm


Yes, according to int, bigint, smallint, and tinyint (Transact-SQL):

bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)


It depends on the RDBMS. For example, the maxiumum values of a BIGINT are 9223372036854775807 (for signed) or 18446744073709551615 (for un-signed) on MySQL.

See the Numeric Types section of the docs for the full details.


Nothing to worry about. BIGINT can store much larger values than the ones you have.

At a minimum up to 9,223,372,036,854,775,807.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜