Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL use the integer type     - Python 3.5 await / async (Programming)

- Ubuntu font settings: Using Windows Font (Linux)

- TOAST function in PostgreSQL (Database)

- Compiled version of Android Opus audio codec library method (Programming)

- Let Ubuntu 14.04 Save screen luminance value (Linux)

- Ubuntu 14.04 install PostgreSQL 9.2 (Database)

- Java and Python use make way dictionary word search script (Programming)

- shell script error dirname: invalid option - b (Database)

- JavaScript: understanding regular expressions (Programming)

- Simple to use Linux GPG (Linux)

- Linux system security infrastructure Highlights (Linux)

- Teamviewer not start in Linux (Linux)

- Android imageView in the Src and Background (Programming)

- Talking about the shortcomings and deficiencies of the firewall (Linux)

- Relationship between Linux permissions with the command (Linux)

- IIS virtual host of safety knowledge (Linux)

- Configuring Sublime Text Python runtime environment 2 (Linux)

- ARM assembler instruction debugging method (Programming)

- Distributed Hadoop1.2.1 cluster installation (Server)

- Creating and extracting archives 11 tar command examples in Linux (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:      
 
- Merge Sort (Programming)
- Eclipse remove all comments and code spaces (Linux)
- The istgt PSD on ported to Mac OS X (Linux)
- Hibernate Search 5.5 in the search results sorted (Linux)
- Ubuntu FAQ solutions (Linux)
- CentOS Set the Mono environment variable (Server)
- Let's Encrypt with semiautomatic into Nginx configuration https (Server)
- Linux program analysis tool: ldd and nm (Linux)
- Simple Calendar C language (Programming)
- Linux Tutorial Share: How to sudo command to define the PATH environment variable (Linux)
- MongoDB polymerization being given (Database)
- Scala REPL Shell call (Programming)
- REDO LOG records management (Database)
- Help you enhance Python programming languages 27 (Programming)
- How to use Xmanager Remote Desktop and VNC Log (Linux)
- Linux server is how to do after the invasion (Linux)
- Linux usage in echo (Linux)
- How to upgrade the kernel to 3.13.7 on Ubuntu / Linux Mint (Linux)
- Linux system security settings (Linux)
- The best known for archiving / compression tool under linux (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.