Skip to content
This repository has been archived by the owner on Oct 9, 2018. It is now read-only.

Latest commit

 

History

History
67 lines (47 loc) · 989 Bytes

DataTypes.md

File metadata and controls

67 lines (47 loc) · 989 Bytes
Raw

Data Types

数据类型

Content

Numeric

  • Integer
  • Floating-Point
  • Fixed-Point
  • BIT

String

Character

  • Text
    • VARCHAR
      • MAX 65,535 characters
  • Integer
    • ENUM
    • SET

Binary

  • Binary
  • BLOB
    • MAX 65,535 bytes

Temporal

  • DATE
  • TIME
  • DATETIME
  • TIMESTAMP
  • YEAR

Spatial

  • Entity
  • Space
  • Definable location

MyISAM supports both spatial and non-spatial indexes.

NULL

The NULL value means "no data."

JSON

Support from MySQL 5.7.8

Reference