Mysql的BigInt(20),Int(20)以及Bigint(32)有区别吗？

Types in MySQL: BigInt(20) vs Int(20) etcc

See 

INT is a four-byte signed integer. BIGINT is an eight-byte signed integer.

The 20 in INT(20) and BIGINT(20) means almost nothing. It\'s a hint for display width, it has nothing to do with storage. Practically, it affects only the ZEROFILL option:

Sql代码