WOLFRAM

Wolfram Language & System Documentation Center
"MySQL" (Data Connection)

"MySQL" (Data Connection)

Details

Properties

  • DataConnectionObject[assoc] creates a reference to a data source. The source does not need to exist yet.
  • General keys typically found in assoc are:
  • "ConnectionName""MySQL"
    "Location"SQL query given as a string
    "Redownload"whether to rerun the query and overwrite cached results
  • Required keys in assoc are:
  • "DatabaseName"string giving the database to access
    "Host"the host servicing the database
  • Typical keys in assoc are:
  • "Port"the server port to access the database
  • Possible forms of "Location" when connecting to a MySQL database include:
  • "query"SQL query given as a string

    • 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

    • Account Setting & Authentication

  • Possible values for Authentication are:
  • Automaticattempt to use saved credentials or give a dialog
    "Dialog"give authentication parameters via a dialog
    SystemCredential["key"]retrieve authentication information from secure storage
    SystemCredentialData[…]stored authentication data
    assocprovide explicit credentials
  • Use the form Authentication:>SystemCredential["key"] to delay evaluating securely stored credentials.
  • The following keys are accepted by Authenticationassoc:
  • "Username"username
    "Password"password

    • Examples

    Basic Examples  (2)

    Create a DataConnectionObject to data from a MySQL query:

    Retrieve the data using Import: