Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-reporting.html
MySQL Shell's reporting facility supports both built-in reports and user-defined reports. Reports can be created directly at the MySQL Shell interactive prompt, or defined in scripts that are automatically loaded when MySQL Shell starts. Section ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
The current Workbench MySQL connections will be available here, or you can choose Manage DB Connections to create a new connection. "Schema Name Mapping Method" options while migrating Microsoft SQL Server: Keep schemas as they are: ... This example ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-showstatementactivity-category.html
Show Create DB (Delta) The total number of SHOW CREATE DATABASE statements executed. Show Create Event (Delta) The total number of SHOW CREATE EVENT statements executed. Show Create Func (Delta) The total number of SHOW CREATE FUNCTION statements ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
Using this method, you can create vector embedding tables that you can use to perform similarity searches using the DISTANCE() function, without setting up a vector store. To learn how to create vector embeddings for unstructured data, see Section ... This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI ...
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/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. Explicit selection of ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/workbench/en/wb-intro.html
MySQL Workbench functionality covers five main topics: SQL Development: Enables you to create and manage connections to database servers. Data Modeling (Design): Enables you to create models of your database schema graphically, reverse and forward ... This chapter provides general information about MySQL Workbench and how it has ...