search
Data type: intFeb 07, 2017 am 11:35 AM

Integer type: int

INT[(M)] [UNSIGNED] [ZEROFILL]

M represents the maximum display width, the maximum is 255, I personally think it is meaningless when the defined value of M is 1 hour, it can also store up to 10 bits of data [Maybe this is just for front-end application display, right? ]

Size: 4 bytes

Storage range:

single(-2^(32-1),2^(32-1)-1]、unsingle(0,2^32-1)


##1.MySQL displays an optional display width indicator The form extends the SQL standard so that when a value is retrieved from the database, the value can be lengthened to a specified length. For example, specifying the type of a field as int(6) can ensure that values ​​containing less than 6 numbers can be automatically filled with spaces when retrieved from the database. It should be noted that using a width indicator does not Affects the size of the field and the range of values ​​it stores.


2. When the number exceeds the permitted range, it will be truncated and stored. Another special thing is that mysql will automatically change the value to 0 before inserting the illegal value into the table.

3. The ZEROFILL modification specifies that 0 (not spaces) can be used to fill the output value. Use this modifier to prevent the MySQL database from storing negative values.

mysql>create table t1(id int,id2int unsigned);
Query OK, 0 rows affected (0.13 sec)

Data type: int


Summary:

The default type of int when creating a table is signed, the default is 11, and the default for unsigned is 10.

int(M) In the integer data type, M represents the maximum display width.

In int(M), the value of M has nothing to do with how much storage space int(M) occupies.

It has nothing to do with the number of digits. int(3), int(4), and int(8) all occupy 4 btyes of storage space on the disk.

The maximum value of M is 255. Because int is an unsigned number, the maximum value is 4294967295 and the width is 10 bits, so it makes no sense to define int (255). So defining the width is meaningless.

The unsigned number defaults to 10, and the signed number defaults to 11, because there is a - sign, the sign bit.

The above is the content of data type: int. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!


Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
dint是什么数据类型dint是什么数据类型Sep 05, 2022 am 11:05 AM

dint是带符号位的32位整数类型;dint的表示方法及范围是“L#-2147483648~L#+2147483647”,定义为双整数或长整数,字节是电脑里的数据量单位,在计算机中,数据只用0和1这种表现形式。

Python时间序列数据操作的常用方法总结Python时间序列数据操作的常用方法总结Apr 24, 2023 pm 10:22 PM

时间序列数据是一种在一段时间内收集的数据类型,它通常用于金融、经济学和气象学等领域,经常通过分析来了解随着时间的推移的趋势和模式Pandas是Python中一个强大且流行的数据操作库,特别适合处理时间序列数据。它提供了一系列工具和函数可以轻松加载、操作和分析时间序列数据。在本文中,我们介绍时间序列数据的索引和切片、重新采样和滚动窗口计算以及其他有用的常见操作,这些都是使用Pandas操作时间序列数据的关键技术。数据类型Python在Python中,没有专门用于表示日期的内置数据类型。一般情况下都

mysql性别用什么类型mysql性别用什么类型Jun 13, 2023 am 11:33 AM

MySQL性别采用多种数据类型来表示性别字段,例如CHAR、ENUM等,最终采用哪种类型,取决于实际需求以及数据存储的大小和性能。

java的数据类型有哪些java的数据类型有哪些Jan 30, 2024 pm 03:23 PM

java数据类型:1、整型;2、浮点型;3、字符型;4、布尔型;5、其他数据类型;6、引用类型;7、原始类型与封装类;8、自动装箱与拆箱;9、可变参数;10、注解;11、枚举;12、原始类型和引用类型的选择。Java是一种强类型语言,因此每种数据都有其固定类型。

decimal是什么类型decimal是什么类型Mar 18, 2021 pm 04:03 PM

decimal是MySQL中存在的精准数据类型,语法格式“DECIMAL(M,D)”。其中,M是数字的最大数(精度),其范围为“1~65”,默认值是10;D是小数点右侧数字的数目(标度),其范围是“0~30”,但不得超过M。

MySQL数据类型详解:你需要知道的知识点MySQL数据类型详解:你需要知道的知识点Jun 15, 2023 am 08:56 AM

MySQL是世界上最流行的关系型数据库管理系统之一,因其可靠性、高安全性、高扩展性以及相对低的成本而得到了广泛应用。MySQL的数据类型定义了各种数据类型的存储方式,是MySQL的重要组成部分。本文将详解MySQL的数据类型,以及在实际应用中需要注意的一些知识点。一、MySQL的数据类型分类MySQL的数据类型可以分为以下几类:整数类型:包括TINYINT、

mysql中银行卡号用什么类型mysql中银行卡号用什么类型Jun 14, 2023 pm 04:34 PM

mysql中银行卡号用“varchar”字符串类型,因为银行卡的号码较长并且全是数字,为了方便存储,就统一存储为字符串类型。如果用“number”类型,会超出“int”类型的最大值范围,必须用“bigInteger”存储,而它不利于数据的正常转换。

表中字段的数据类型有哪些表中字段的数据类型有哪些Jan 19, 2021 am 10:18 AM

表中字段的数据类型有:1、二进制类型,包括Binary、Varbinary、Image;2、字符串类型,包括CHAR、VARCHAR、TEXT等;3、Unicode数据类型,包括Nchar,Nvarchar和Ntext;4、日期和时间数据类型,包括DATE、TIME、YEAR等;5、数值数据类型,包括INT、FLOAT、BIGINT等;6、货币数据类型;7、特殊数据类型等等。

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Tools

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!