"MySQL"Listing of Supported Databases »
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
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
Introduced in 2020