What is the range of values for a MySQL bigint data typ…

1 year ago
Emily Johnson
1 minute

In MySQL, BIGINT is an integer data type that can store a wide range of integer values. It ranges from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (or -(2^63) to (2^63)-1).

The specific range of values is as follows:

Minimum value: -9,223,372,036,854,775,808.

Maximum value: 9,223,372,036,854,775,807.

For example, when creating a column with BIGINT type, you can use the following syntax:

CREATE TABLE my_table (
   id BIGINT
);

This will create a column named id of type BIGINT, which can store very large integer values.

Please note that the BIGINT data type takes up more storage space, so it’s important to consider its use when designing database tables. If you only need to store a small range of integer values, consider using other more fitting integer types, such as INT or SMALLINT.

bannerAds