- Preface and Legal Notices
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Security
- 7 Backup and Recovery
- 8 Optimization
- 9 Language Structure
- 10 Globalization
- 11 Data Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 Storage Engines
- 15 High Availability and Scalability
- 16 Replication
- 17 MySQL Cluster NDB 6.1 - 7.1
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- 23 MySQL Enterprise Edition
- 24 MySQL Workbench
- 25 MySQL for Excel
- A Licenses for Third-Party Components
- B MySQL 5.1 Frequently Asked Questions
- C Errors, Error Codes, and Common Problems
- D MySQL Release Notes
- E Restrictions and Limits
- General Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Join Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Statement/Syntax Index
- System Variable Index
- Status Variable Index
Table of Contents [+/-]
- 11.1. Data Type Overview [+/-]
- 11.2. Numeric Types [+/-]
- 11.2.1. Integer Types (Exact Value) -
INTEGER,INT,SMALLINT,TINYINT,MEDIUMINT,BIGINT - 11.2.2. Fixed-Point Types (Exact Value) -
DECIMAL,NUMERIC - 11.2.3. Floating-Point Types (Approximate Value) -
FLOAT,DOUBLE - 11.2.4. Bit-Value Type -
BIT - 11.2.5. Numeric Type Attributes
- 11.2.6. Out-of-Range and Overflow Handling
- 11.2.1. Integer Types (Exact Value) -
- 11.3. Date and Time Types [+/-]
- 11.3.1. The
DATE,DATETIME, andTIMESTAMPTypes - 11.3.2. The
TIMEType - 11.3.3. The
YEARType - 11.3.4.
YEAR(2)Limitations and Migrating toYEAR(4) - 11.3.5. Automatic Initialization and Updating for
TIMESTAMP - 11.3.6. Fractional Seconds in Time Values
- 11.3.7. Conversion Between Date and Time Types
- 11.3.8. Two-Digit Years in Dates
- 11.3.1. The
- 11.4. String Types [+/-]
- 11.5. Data Type Default Values
- 11.6. Data Type Storage Requirements
- 11.7. Choosing the Right Type for a Column
- 11.8. Using Data Types from Other Database Engines
MySQL supports a number of data types in several categories: numeric types, date and time types, and string (character and byte) types. This chapter provides an overview of these data types, a more detailed description of the properties of the types in each category, and a summary of the data type storage requirements. The initial overview is intentionally brief. The more detailed descriptions later in the chapter should be consulted for additional information about particular data types, such as the permissible formats in which you can specify values.
MySQL also supports extensions for handling spatial data. For information about these data types, see Section 12.17, “Spatial Extensions”.
Data type descriptions use these conventions:
Mindicates the maximum display width for integer types. For floating-point and fixed-point types,Mis the total number of digits that can be stored (the precision). For string types,Mis the maximum length. The maximum permissible value ofMdepends on the data type.Dapplies to floating-point and fixed-point types and indicates the number of digits following the decimal point (the scale). The maximum possible value is 30, but should be no greater thanM–2.Square brackets (“
[” and “]”) indicate optional parts of type definitions.
User Comments
Add your own comment.