Search Results
https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html
NESTED [PATH] path COLUMNS (column_list): This flattens nested objects or arrays in JSON data into a single row along with the JSON values from the parent object or array. Using multiple PATH options allows projection of JSON values from multiple ...
https://dev.mysql.com/doc/refman/9.7/en/replication-upgrade.html
Upgrade the old source according to the procedure for a single server, and then reinsert it into the topology. For each replica, take out the replica from the topology, wait for it to apply all its relay log, downgrade it following the instructions ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-predictions-ml-predict-table.html
If you specify the output table and the input table as the same name, the predictions are inserted into the input table. After generating predictions on a table, learn how to Generate Explanations on a table to get insights into which features have ... ML_PREDICT_TABLE generates predictions for an entire table of trained ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/9.7/en/news-9-4-0.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed NDB Replication: It is now possible to divide binary logging for a MySQL Cluster or for individual NDBCLUSTER tables into equal portions or “slices” between multiple MySQL ... MySQL NDB Cluster 9.4.0 is a new Innovation release of NDB Cluster, based on MySQL Server 9.4 and including features in version 9.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
This executes a "SELECT * FROM schema.table" query and loads the results into the result grid. Next, load this file into your new Workbench instance by using the related Restore Connections option. How do I import comma-separated values (CSV) data ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
With this integration, you can easily track performance metrics, monitor resource utilization, and gain insights into operational health for your systems. 2025-03-17: New Summary Panes for Data Loading and Refreshing Issues for MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The following example describes how to export MyISAM tables named employees and managers ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...
https://dev.mysql.com/doc/refman/9.7/en/select.html
[into_option] [FROM table_references [PARTITION partition_list]] [WHERE where_condition] [GROUP BY [ {col_name | expr | position}, ... [WITH ROLLUP]] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [into_option] [FOR {UPDATE | SHARE} [OF ...
https://dev.mysql.com/doc/refman/9.7/en/window-function-descriptions.html
This function should be used with ORDER BY to sort partition rows into the desired order. This function should be used with ORDER BY to sort partition rows into the desired order. NTILE(N) over_clause Divides a partition into N groups (buckets), ...
https://dev.mysql.com/doc/connectors/en/connector-j-YEAR.html
Connector/J follows the same rules that govern how values are inserted by a mysql client; see explanations in The YEAR Type for details. Treatments of zero values depend on whether they are strings or numbers, and on the value of yearIsDateType: If ... How a value in a MySQL YEAR column is handled is controlled by the connection property yearIsDateType: If yearIsDateType is true (the default), YEAR is mapped to the Java data type ...