Mysql Imp Questions

  2. design related DB questions –
  3. I was wondering what the difference between BigInt, MediumInt, and Int are… it would seem obvious that they would allow for larger numbers; however, I can make an Int(20) or a BigInt(20) and that would make seem that it is not necessarily about size. SOSO
    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.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s