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、

表中字段的数据类型有哪些表中字段的数据类型有哪些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、特殊数据类型等等。

PHP8中支持的新数据类型可以让你的代码变得更加清新PHP8中支持的新数据类型可以让你的代码变得更加清新Jun 21, 2023 am 11:20 AM

随着PHP8的发布,这个流行的编程语言引入了新的数据类型,这些新类型可以大大简化代码并提高代码的可读性。在本文中,我们将介绍PHP8中的四种新类型:联合类型、命名参数、只读属性和允许为空的属性,并解释它们如何为开发者带来更好的编程体验。联合类型联合类型是PHP8中引入的一种新类型,它可以让开发者在一个变量中存储多种不同类型的值。例如,一个变量可以

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 Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment