Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema specification. MySQL supports the required attribute in JSON schemas to enforce the inclusion of required properties (see the examples in the ...This can be done using either of the functions detailed in this section, both of which take two arguments, a JSON schema, and a JSON document which is validated against the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
This example migrates a Microsoft SQL Server database to MySQL and includes an image for each step. From MySQL Workbench, choose Database and then Migrate to open the migration wizard and display the migration wizard overview (see the figure that ...The Open ODBC Administrator option will load odbcad32.exe, and is used to confirm that the ODBC Driver for SQL Server is installed, and to make configuration changes if ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage bucket. mysql> CREATE DATABASE ...This ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
The mysql.gtid_executed system table is used to preserve the assigned GTIDs of all the transactions applied on a MySQL server, except those that are stored in a currently active binary log file. GTID sets are used in a MySQL server in several ways.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-building-clients.html
This section provides guidelines for compiling C programs that use the MySQL C API. Compiling MySQL Clients on Unix Compiling MySQL Clients on Microsoft Windows Troubleshooting Problems Linking to the MySQL Client Library Compiling MySQL Clients on ...A different compiler might be appropriate on some systems (for example, clang on macOS or FreeBSD, or Sun Studio on ...
https://dev.mysql.com/doc/connector-net/en/connector-net-authentication.html
MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to authenticate a user. Connector/NET provides the following authentication plugins and methods: authentication_kerberos_client ...Pluggable ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-program-reference-server-script-config.html
Note The parameters listed here, with the exception of the four repository connection parameters, correspond to those displayed on the Welcome to MySQL Enterprise Monitor page used for initial setup. Important These parameters enable you to ...The ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last started. The counter is reset to 0 when the MySQL HeatWave Cluster is restarted (when the rapid_bootstrap state changes from OFF or IDLE ...The value of this variable is a JSON object containing two string fields: status and ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different keystore. This pertains to migration strategy because the way in which the source and destination keystores are managed ...A ...