Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-monitoring.html
Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be created. If the server cannot create a given instrumented mutex instance, it increments Performance_schema_mutex_instances_lost. INSTALL PLUGIN ...
https://dev.mysql.com/doc/refman/9.7/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. Stored function: An object created with CREATE FUNCTION and used much like a built-in function. Trigger: An ...
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/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/refman/9.7/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/9.7/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/9.7/en/replication-features-js-programs.html
A JavaScript stored program created on a server without the component installed is not checked for validity. This means that, when a CREATE FUNCTION or CREATE PROCEDURE statement without USING, and which contains invalid JavaScript code, is executed ...If the replica has the MLE component installed, an error is raised when the replica attempts to execute such a statement, leading to a break in ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...