Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL use the integer type     - Install and manage Java under mac (Linux)

- Git version rollback (Linux)

- Windows 8.1 and Ubuntu 14.04 dual system uninstall Ubuntu Tutorial (Linux)

- Linux ldconfig command (Linux)

- MySQL 5.6.12 binary log path switching binlog (Database)

- MySQL concat function is SQL injection (Linux)

- CentOS7 minimized installation can not find the 'ifconfig' command - Repair Tips (Linux)

- Ubuntu 14.04 VirtualBox can not start solution (Linux)

- Linux common network tools: batch scanning of hosting services netcat (Linux)

- Android Studio and Git Git configuration file status (Linux)

- Linux character device - a simple character device model (Linux)

- Linux modify the network interface name (Linux)

- Hadoop 2.5 Pseudo distribution installation (Server)

- C ++ precision performance test function (Programming)

- Ubuntu 10.10 install Oracle 10g Installation Guide (Database)

- Java programmers talk about those advanced knowledge and direction (Programming)

- Configuring a Linux operating system security management services Explain (Linux)

- Windows Ubuntu dual system a key Ghost, grub rescue prompt solution (Linux)

- Use install_updates upgrade GAMIT / GLOBK (Linux)

- MySQL binlog automatic cleanup script (Database)

 
         
  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:      
 
- map and hash_map STL containers (Programming)
- Linux kernel source tree to establish load module hello (Linux)
- ORA-08102 errors (Database)
- First start with Kali Linux 2.0 (Linux)
- Sublime Text 3 practical functions and shortcut keys used to collect (Linux)
- Oracle Database Restore (Database)
- SME Linux network security policy server security (Linux)
- Install snort intrusion detection system on Debian (Linux)
- Ubuntu use three methods to install Ruby (Linux)
- C ++ constant definition (Programming)
- Start Linux ISO image directly from the hard disk (Linux)
- GitLab remote backup of Linux Shell Scripting (Linux)
- Linux uses the SMTP proxy to send mail (Linux)
- Java abstract class instantiation (Programming)
- Oracle 11g em start newspaper site's security certificate has a solution to the problem (Database)
- Java look and feel mode (Facade mode) (Programming)
- Analysis: Little Notebook facing a major security threat secure online (Linux)
- Git / Github use notes (Linux)
- Teach you how to choose to install CentOS 6.5 installation package (Linux)
- MySQL to NoSQL avatar (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.