Details

  • MySQL is an open source relational database management system.

Connecting & Authenticating

  • When configuring MySQL using DatabaseReference[URL["url"]], "url" is typically of the form "mysql://user:password@host:port/name".
  • In DatabaseReference[assoc], typical elements of assoc include:
  • "Backend"the type of SQL backend used
    "Name"the name of the database
    "Host"the host serving the database
    "Port"the server port through which to access the database
    "Username"the username used to authenticate the database
    "Password"the password used to authenticate the database

Supported Types

  • BOOLEANTrue or False
    BINARY, BLOB, LONGBLOB, MEDIUMBLOB, TINYBLOB, VARBINARYByteArray
    DATEDateObject with Day granularity
    DATETIMEDateObject with Instant granularity
    TIMESTAMPDateObject with Instant granularity and time zone support
    DECIMAL, NUMERICReal with fixed precision
    BIGINT, INTEGER, MEDIUMINT, SMALLINT, TINYINT, YEARInteger
    DOUBLE, FLOAT, REALReal
    CHAR, LONGTEXT, MEDIUMTEXT, NCHAR, NVARCHAR, TEXT, TINYTEXT, VARCHARString
    TIMETimeObject

Notes & Issues

  • For MySQL connections, DATETIME with time stamps are always returned as UTC.

Examples

Basic Examples  (1)

Create a MySQL connection using the URL wrapper:

The canonical form of a DatabaseReference for MySQL uses Association:

Introduced in 2020
 (12.1)