All Collections
Database Object and Feature Support
MySQL Support Summary
MySQL Support Summary
S
Written by Serge Gershkovich
Updated over a week ago

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

Objects and properties

  • Schemas

    • Collation

  • Tables

    • Constraints

    • 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:

Did this answer your question?