Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-single-document-operations.html
Collection.replaceOne(string id, Document doc) updates or replaces the document identified by id, if it exists, with the provided document. Collection.addOrReplaceOne(string id, Document doc) adds the given document; however, if the id or any other ... The CRUD commands described at Section 4.3, “Collection CRUD Function Overview” all act on a group of documents in a collection that match a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-single-document-operations.html
Collection.replaceOne(string id, Document doc) updates or replaces the document identified by id, if it exists, with the provided document. Collection.addOrReplaceOne(string id, Document doc) adds the given document; however, if the id or any other ... The CRUD commands described at Section 4.3, “Collection CRUD Function Overview” all act on a group of documents in a collection that match a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-data-drift-detection.html
mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', JSON_OBJECT('task', 'task_name'), @variable); Replace table_name, target_column_name, task_name, and variable with your own values. mysql> SELECT JSON_PRETTY(model_metadata) FROM ... MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
mysql> CALL sys.NL2ML (query, response); Replace query with your question in natural language, and response with the name of the session variable that has the generated answer to your question. | | \n\n```mysql\nSELECT sys.ML_PREDICT_ROW(@new_order, ... Available as of MySQL 9.4.0, the NL2ML routine enables you to learn about MySQL HeatWave AutoML by leveraging Oracle Cloud Infrastructure Generative AI (OCI) and asking questions in natural ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
mysql> SET @variable = 'model_handle'; Replace @variable and model_handle with your own definitions. mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', JSON_OBJECT('task', 'task_name'), @variable); Replace table_name, target_column_name, ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can precede the SELECT by IGNORE or REPLACE to indicate how to handle rows that duplicate unique key values. With REPLACE, new rows replace rows that have the same unique key value. If neither IGNORE nor REPLACE is specified, duplicate unique ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
Terms then can then be added, removed, and selected from dictionaries and used as random values or as replacements for other values. Its arguments are the term to replace, the dictionary in which the term appears, and the dictionary from which to ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Items then can be selected from registered dictionaries and used as random values or as replacements for other values. Its arguments are the term to replace, the dictionary in which the term appears, and the dictionary from which to choose a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
This includes single-row and multiple-row INSERT and REPLACE statements that do not have a nested subquery, but not INSERT ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
For a comparison of JSON_INSERT(), JSON_REPLACE(), and JSON_SET(), see the discussion of JSON_SET(). If the second object has a member with a key matching a member in the first object, JSON_MERGE_PATCH() replaces the value in the first object with ... The functions in this section modify JSON values and return the ...