Search Results
https://dev.mysql.com/doc/refman/8.4/en/what-is-mysql.html
The database structures are organized into physical files optimized for speed. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or ... MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
FROM t1 WHERE NOT IN(SELECT ...) were transformed into an antijoin if possible, causing the optimizer not to choose a group skip scan for table t1 whereas it would have been chosen in MySQL 5.7. The same behavior can be seen for queries which are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-single-file.html
The resulting file or directory goes into the current directory, or into the backup directory, if specified with --backup-dir; in either case, the destination directory must be empty. The --dst-entry=path option, along with --src-entry=path option, ... Besides the commands for creating and restoring single-file backups (namely, backup-to-image and copy-back-and-apply-log), mysqlbackup provides a number of other commands for you to work with single-file ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-cluster.html
See also Section 4.5, “Importing MySQL NDB Clusters into MySQL Cluster Manager”. Caution While it is possible to import into a cluster that was created without this option, it is not advisable, since the cluster is not protected against ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
The string in the from argument is encoded to produce an escaped SQL string, taking into account the current character set of the connection. Return Values The length of the encoded string that is placed into the to argument, not including the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-remove.html
clusterSet.removeCluster() has the following syntax: clusterSet.removeCluster(clusterName[, options]) Clusters can be removed from a ClusterSet by removing the Cluster, but leaving it intact, or by removing the Cluster and dissolving it into its ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-requirements.html
The basis of an InnoDB ClusterSet deployment is an existing InnoDB Cluster at MySQL 8.0.27 or higher, and a number of standalone MySQL Server instances that can be formed into replica clusters to provide disaster tolerance for this primary cluster.
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-explanations-ml-explain-row.html
The following example enters a row of data to explain into a session variable. mysql> SET @variable = (JSON_OBJECT("column_name", value, "column_name", value, ...), model_handle, options); In the following example, assign the data to analyze into ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-predictions-ml-predict-row.html
Inputting Data to Generate a Row Prediction One way to generate predictions on row data is to manually enter the row data into a session variable, and then generate a prediction by specifying the session variable. mysql> SET @variable = ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-results.html
Export or Import data directly from or into the result set. Figure 6.23 Exporting a Result Set Import into a Result Set Records from a CSV file can be imported into the result set of the visual SQL editor. The export and import operations shown in ...