MySQL.Database

The function retrieves a list of tables, views, and stored scalar functions available in a MySQL database on a specified server and database instance. The port can be specified with the server address...

Syntax

MySQL.Database(server as text, database as text, optional options as nullable record) as table.

About

The function retrieves a list of tables, views, and stored scalar functions available in a MySQL database on a specified server and database instance. The port can be specified with the server address. An optional parameter, options, can be used to configure several settings: - Encoding: Specifies the character set used for queries to the server (default is null). - CreateNavigationProperties: Determines whether to generate navigation properties on returned values (default is true). - NavigationPropertyNameGenerator: Controls the naming of navigation properties. - Query: Allows for a custom SQL query to fetch data; only the first result set is returned if multiple are produced. - CommandTimeout: Sets a maximum duration for server-side queries before cancellation (default is ten minutes). - ConnectionTimeout: Specifies how long to wait before abandoning a connection attempt to the server (default is driver-dependent). - TreatTinyAsBoolean: Decides whether to interpret tinyint columns as logical values (defau

Explanation

The record parameter should be defined in the format [option1 = value1, option2 = value2...] or [Query = "select ..."].