Search Results
https://dev.mysql.com/doc/refman/9.7/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/9.7/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. That is, you can include index declarations in the table definition. Inserts into a BLACKHOLE table do not store any data, but if statement ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. Is it possible for a trigger to update tables on a remote server? A.5.12. Information about triggers can be obtained by querying the INFORMATION_SCHEMA.TRIGGERS ...Where can I find the documentation for MySQL 9.7 triggers? ...
https://dev.mysql.com/doc/refman/9.7/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-limits.html
Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. --dns-srv-name=name Command-Line Format --dns-srv-name=name Type String Specifies the name of a DNS SRV record that determines the candidate hosts to use for ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
The following example demonstrates the use of a JavaScript stored function with table column values. First we create a table t2 containing three integer columns, like this: mysql> CREATE TABLE t2 (c1 INT, c2 INT, c3 INT); Query OK, 0 rows affected ... This section contains examples illustrating a number of different aspects of using JavaScript programs under various ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-llm.html
LLM Constructor LLM.unload() LLM.generate() LLM.embed() LLM.rag() This class represents a large language model. The API also provides convenience methods; see Section 27.3.10.8, “Convenience Methods”. Both versions of these methods support ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-model-sharing.html
ML_MODEL_EXPORT exports the model to share to a user-defined table that both users need the required privileges to access. Export the Model to Share The admin user needs to export the model to share to a user-defined table that both users can access. mysql> CALL sys.ML_MODEL_EXPORT (model_handle, output_table_name); Replace model_handle and output_table_name with your own ...