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...
MySQL.Database(server as text, database as text, optional options as nullable record) as table.
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