Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 to a MySQL HeatWave Lakehouse table. Once the S3 data is provided, the schema for the ...Note: To map and load data into Lakehouse, the Amazon S3 bucket in which the data is located and the DB System must be in the same ...
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 ...