Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how

Wolfram Language & System Documentation Center

"MySQL"

"MySQL"

Listing of Supported Databases »

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

BOOLEAN True or False

BINARY, BLOB, LONGBLOB, MEDIUMBLOB, TINYBLOB, VARBINARY ByteArray

DATE DateObject with Day granularity

DATETIME DateObject with Instant granularity

TIMESTAMP DateObject with Instant granularity and time zone support

DECIMAL, NUMERIC Real with fixed precision

BIGINT, INTEGER, MEDIUMINT, SMALLINT, TINYINT, YEAR Integer

DOUBLE, FLOAT, REAL Real

CHAR, LONGTEXT, MEDIUMTEXT, NCHAR, NVARCHAR, TEXT, TINYTEXT, VARCHAR String

TIME TimeObject

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 :

See Also

RelationalDatabase DatabaseReference DatabaseConnect DatabaseDisconnect

History

Introduced in 2020 (12.1)

Top [フレーム]