MySQL and MariaDB¶

MySQL SQL Constructs¶

MySQL Data Types¶

As with all SQLAlchemy dialects, all UPPERCASE types that are known to be valid with MySQL are importable from the top level dialect:

from sqlalchemy.dialects.mysql import (
    BIGINT,
    BINARY,
    BIT,
    BLOB,
    BOOLEAN,
    CHAR,
    DATE,
    DATETIME,
    DECIMAL,
    DECIMAL,
    DOUBLE,
    ENUM,
    FLOAT,
    INTEGER,
    LONGBLOB,
    LONGTEXT,
    MEDIUMBLOB,
    MEDIUMINT,
    MEDIUMTEXT,
    NCHAR,
    NUMERIC,
    NVARCHAR,
    REAL,
    SET,
    SMALLINT,
    TEXT,
    TIME,
    TIMESTAMP,
    TINYBLOB,
    TINYINT,
    TINYTEXT,
    VARBINARY,
    VARCHAR,
    YEAR,
)

Types which are specific to MySQL, or have MySQL-specific construction arguments, are as follows:

MySQL DML Constructs¶

mysqlclient (fork of MySQL-Python)¶

PyMySQL¶

MariaDB-Connector¶

MySQL-Connector¶

asyncmy¶

aiomysql¶

cymysql¶

OurSQL¶

pyodbc¶

PostgreSQL

SQLite