MySQL Support Summary

SqlDBM Support

May 30, 2025 17:18 Updated

This article summarizes the features, objects, properties, and data types that are available for MySQL projects.

Objects and properties

Schemas
- Collation
Tables
- Constraints
  - PK
  - FK
  - AK (UNIQUE)
  - CHECK
    - Expression
    - Not enforced
- Index
  - Storage type
    - Btree
    - Hash
  - Key block size
- Fulltext Index
  - Storage type
    - Btree
    - Hash
  - Key block size
- Spatial Index
  - Storage type
    - Btree
    - Hash
  - Key block size
- Options
  - Engine
    - Archive
    - CSV
    - Example
    - Federated
    - Heap
    - InnoDB
    - Memory
    - Merge
    - MyISAM
    - NDB
  - Collation
- Row Options
  - Row Format
    - Default
    - Dynamic
    - Fixed
    - Compressed
    - Redundant
    - Compact
  - Avg row length
  - Min rows
  - Max rows
- Comment/Description
- Post Script
Columns
- Data type (see summary of types below)
- (NOT) NULL
- Default
- Auto increment
- Unsigned
- Zero fill
- Generated
- Stored
- Collation
- Comment/Description

Data types

Numeric Data Types
- DECIMAL
- NUMERIC
- INTEGER
- INT
- TINYINT
- SMALLINT
- MEDIUMINT
- BIGINT
- SERIAL
- BIT
- FLOAT
- DOUBLE
- DOUBLE PRECISION
- REAL
String & Binary Data Types
- VARCHAR
- CHAR
- TINYTEXT
- TEXT
- MEDIUMTEXT
- LONGTEXT
- ENUM('')
- SET
- BINARY
- BLOB
- VARBINARY
- TINYBLOB
- MEDIUMBLOB
- LONGBLOB
Date & Time Data Types
- DATE
- DATETIME
- YEAR
- TIME
- TIMESTAMP
Geospatial Data Types
- GEOMETRY
- GEOMETRYCOLLECTION
- POINT
- MULTIPOINT
- POLIGON
- MULTIPOLIGON
- LINESTRING
- MULTILINESTRING

See also: