Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
Learn how to create a DB System and edit a DB System in Oracle Cloud Infrastructure (OCI). This creates an asynchronous task in the background which loads the vector embeddings into the specified vector store table quickstart_embeddings. It analyzes ... This quickstart shows how to set up a GenAI-powered Help Chat that uses the information available in MySQL HeatWave User Guide to provide answers to MySQL HeatWave-related ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
External Tables When MySQL HeatWave loads data and creates a table from a file in Object Storage, it is an external Lakehouse table. Lakehouse Engine The lakehouse storage engine allows you to create tables that point to external data sources. As of ... The Lakehouse feature of MySQL HeatWave enables query processing on data in Object ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
This quickstart contains the following sections: tpch Requirements Generate tpch Sample Data Create the tpch Sample Database and Import Data Load tpch Data Into MySQL HeatWave Run tpch Queries Additional tpch Queries Unload tpch Tables tpch ... The ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
DEFINER The account named in the DEFINER clause (often the user who created the event), in 'user_name'@'host_name' format. EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
We can verify this behavior by examining the effects on the file system of creating a table partitioned by HASH and populating it with a record containing appropriate values. Partitioning in MySQL does nothing to disallow NULL as the value of a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
For more information about permitted partitioning column types and partitioning functions, see Section 26.2, “Partitioning Types”, as well as Section 15.1.20, “CREATE TABLE Statement”, which provides partitioning syntax descriptions and ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. On Windows, you can create a ... On ...