Java long to MySql

What is the equiva开发者_运维百科lent of a Java long in the context of MySql variables?

SIGNED BIGINT is a 8-bytes long integer just like Java's long.

Java long max value is positive: 9,223,372,036,854,775,807

This means for positive only unsigned numbers UNSIGNED BIGINT(19) should be enough or you can just use UNSIGNED BIGINT which is equal to UNSIGNED BIGINT(20)

If you are going to use negative numbers as well BIGINT(19) will be enough.