Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - What is the function of m in integer data type (m) in mysql?
What is the function of m in integer data type (m) in mysql?
Integer data column type

MySQL has five types of integer data columns, namely TINYINT, SMALLINT, MEDIUMINT, INT and BIGINT. The difference between the two is that the range of values is different and the storage space is different.

Adding an unsigned attribute after an integer data column can suppress negative numbers, and the value starts from 0.

When declaring an integer data column, we can specify a display width M( 1~255), such as INT(5), and specify a display width of 5 characters. If the display width is not specified for it, MySQL will specify a default value for it. The display width is only used for display, and the value range and occupied space cannot be limited. For example, INT(3) will occupy 4 bytes of storage space, and the maximum allowable value will not be 999, but the maximum allowable value of INT integer.

Related articles
  • What are the precautions before breast plastic surgery?
  • Comparison of garlic nose plastic surgery
  • The retention period for credit reporting agencies to store negative personal information
  • What do you think of going to Korea for plastic surgery and chest plastic surgery? Do you think that women who do breast enhancement are very material? Is it leisure?
  • What are the signs before it rains?
  • What are the steps of grape pruning technology?
  • What is the relationship between shrinkage and fineness of clay body?
  • What did Liu Zichen, an online celebrity, say when he exposed himself in front of COVID-19?
  • Where is the best cosmetic surgery?
  • Which hospital in Shenzhen is good for double eyelids?

    • copyright 2024 Plastic Surgery and Aesthetics Network All rights reserved