Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > MySQL数据库设计之各种INTEGER类型最佳实践_MySQL

MySQL数据库设计之各种INTEGER类型最佳实践_MySQL

WBOY
Release： 2016-05-30 17:11:28
Original
1757 people have browsed it
MySQL 各种 INTEGER 类型占用存储空间、取值范围一览表
MySQL 各种 INTEGER 类型占用存储空间、取值范围一览表.png
最佳实践
UNSIGNED 只能存储非负整数SIGNED 可以存储正整数、0、负整数对于总是正整数的存储(比如主键)的最佳实践是 UNSIGNED，因为这时它占用和 SIGNED 一样的存储空间，但取值范围多出一倍BOOL、BOOLEAN 只不过是 TINYINT(1) 的另外一种写法而已TINYINT(1)、BOOL、BOOLEAN 所占用的存储空间和 TINYINT 一样，都是一个字节，而不是一位TINYINT(1) 所能存储的值的范围和 TINYINT 一样，都是 -128 到 127TINYINT(1) 只是在显示的时候作为一个位进行输出而已
Related labels：
database type
source：php.cn
Previous article：MySQL 从一张表update字段到另外一张表中_MySQL Next article：MYSQL更新优化实录_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Set a private member of a class as a constructor parameter classFoo{#one#two#three#four#five#six#seven#eight#nine#ten#eleven#twelve#thirteen#fourteen...
From 2024-04-06 21:48:47
0
1
637
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Creating this specific design using a grid: a step-by-step guide I'm trying to create a layout similar to this image, I've tried using this grid but can't ...
From 2024-04-06 20:29:08
0
2
492
Select woocommerce related products using custom taxonomy with 3 level hierarchy I have a woocommerce store with a custom classification of "Sports". The classif...
From 2024-04-06 20:05:30
0
1
544
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template