Mysql Imp Questions

  1. https://www.quora.com/What-are-some-of-the-best-MySQL-interview-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.
Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s