Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
Stored routines can be particularly useful in certain situations: When multiple client applications are written in different languages or work on different platforms, but need to perform the same database operations. In such a setup, applications ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. If not already done, create and use the database to store the data. mysql> CREATE DATABASE anomaly_log_data; mysql> USE anomaly_log_data; ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-supported-models.html
This topic provides the list of languages that GenAI feature of MySQL AI supports and the embedding models as well as large language models (LLMs) that are available. The quality of the generated text outputs depends on the training and ability of ...
https://dev.mysql.com/doc/workbench/en/wb-routine-groups.html
They may be added to an EER diagram by dragging and dropping them from this palette. Make sure that you associate the new routine group with a database. 9.1.6.2.1 Adding Routine Groups to the Physical Schemata Double-clicking the Add Routine Group ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
The CREATE DATABASE statement permits a default encryption to be specified. This section summarizes how the MySQL Workbench 8.0 release series progressed with each minor release. New requirements for the CHANGE MASTER TO replication statement (row ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-rdo.html
The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and rs.update. SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
Used if the storage engine needs to perform special steps when a schema is dropped (such as in a storage engine that uses tablespaces). The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-collections-basic-crud.html
bind('param1','L%').bind('param2',20).execute(); // Print document print(docs.fetchOne()); // Drop the collection myDb.dropCollection('my_collection'); . Working with collections of documents is straightforward when using X DevAPI. The following ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-collections-basic-crud.html
Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: ...