Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL use the integer type     - The Java Properties class action (Programming)

- How linux network security configuration (Linux)

- Wireshark basic introduction and learning TCP three-way handshake (Linux)

- Linux Fundamentals of the memory management mechanism (Linux)

- Oracle PL / SQL based cursor (Database)

- C ++ CBitmap, HBitmap, Bitmap difference and contact (Programming)

- VMware installed Linux system and JDK deployment (Linux)

- CentOS 6.2 install git error Perl5 (Linux)

- Linux directory structure (Linux)

- Solaris 10 installation configuration mrtg monitoring system (Linux)

- Fedora 19/20 and Debian Jessie / Sid users to install FFmpeg 2.3.2 (Linux)

- Linux installation is larger than 2TB (UEFI interface) hard disk solution (Linux)

- Ubuntu 14.04 / 13.10 users how to install Ubuntu Touch core applications (Linux)

- CRF ++ Linux use (Linux)

- Object-C in the preparation of multi-parameter function parameter is omitted (Programming)

- The SVN installation, configuration and start - up under Linux (CentOS 6.5) (Server)

- High-performance JavaScript reflows and repaints (Programming)

- PXE install CentOS 6.4 (Linux)

- TCP protocol flaw incomplete records (Linux)

- Use NTFS-3G to mount NTFS partitions under Linux U disk and removable hard disk (Linux)

 
         
  MySQL use the integer type
     
  Add Date : 2018-11-21      
         
       
         
  MySQL use the integer type

bigint
From -2 ^ 63 (-9223372036854775808) to 2 ^ 63-1 (9223372036854775807) integer data (all numbers). Storage size is 8 bytes.
P.S. bigint has a length, length built in mysql table, just for display digits
int
From -2 ^ 31 (2,147,483,648) to 2 ^ 31--1 (2,147,483,647) integer data (all numbers). Storage size is 4 bytes. int The SQL-92 synonyms for the integer.
smallint
From -2 ^ 15 (-32,768) to 2 ^ 15--1 (32,767) integer data. Storage size is 2 bytes.
tinyint
From 0-255 integer data. Storage size is 1 byte.
Note
In support of local support bigint integer data types. However, bigint for some special cases, when an integer value exceeds the range supported by the int data type, you can use bigint. In SQL Server, int data type is the primary integer data type.
In the Data Type priorities table, bigint located between smallmoney and int.
Only when the parameter expression is bigint data type, the function does not return bigint. SQL Server does not automatically other integer data types (tinyint, smallint and int) promoted to bigint.
int (M) in the integer data types, M indicates the maximum display width. In int (M), M is the value with int (M) occupied much storage does not have any relationship. And digits are unrelated int (3), int (4), int (8) on a disk are occupied by 4 btyes storage space.
     
         
       
         
  More:      
 
- Manage SQL Server services login (start) account and password (Database)
- How to configure MariaDB replication in CentOS Linux (Database)
- Oracle 11g RMAN virtual private directory (Database)
- What is Java EE (Programming)
- MySQL Tutorial: Building MySQL Cluster under Linux (Database)
- Using FTPClient to upload and download files in Java (Programming)
- Ubuntu and derivatives installation Atom 0.104.0 (Linux)
- In-depth understanding of capture Node.js garbage collection and memory leaks (Programming)
- SUSE Linux install Oracle 10g and problem solving (Linux)
- SpringMVC garbage processing (Programming)
- CentOS 6.5 installation using a data recovery software extundelete (Linux)
- CentOS6 5 source compiler installation Hadoop2.5.1 (Server)
- Hadoop 2.6.0 standalone configuration and pseudo-distributed configuration under Ubuntu 14.04 (Server)
- MongoDB collection data migration to MySQL database (Database)
- C ++ inline functions (Programming)
- VirtualBox virtual machine to install Linux (Linux)
- MySQL 5.7.9 source compiler installation instructions (Database)
- Linux user opens a number of adjustment processes (Linux)
- VMware virtual machine operating system log Error in the RPC receive loop resolve (Linux)
- Perl loop (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.