which type to choose for the numerical values with a length of 21 sign?
Google gives user id numeric value 21 sign
in what field to store such data so that it is then relatively rapidly select the user.
asked October 3rd 19 at 03:24
In the row store, select char, fixed. The muscle is quite good digest of the string fixed length
BIGINT[(M)] [UNSIGNED] [ZEROFILL]
A large integer. With a sign range from -9223372036854775808 to 9223372036854775807. The range unsigned 0 to 18446744073709551615. For columns of type BIGINT, you must consider certain features:
In C# "System.Numerics.BigInteger".
Split into two columns, eg. INT + BIGINT
Find more questions by tags MySQL