Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
For example, utf8mb4_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8mb4 collations. In Japan, since the supplementary characters are obscure Kanji ideographs, the typical user does not care ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
The table can be accessed freely by the session within which it was created, regardless of what other locking may be in effect. The following statements are prohibited while a LOCK TABLES statement is in effect: CREATE TABLE, CREATE TABLE ... LIKE, ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
The namespace enables different applications to use the same lock names without colliding by creating locks in separate namespaces. This is distinct from, for example, locks acquired with the GET_LOCK() function, which have an OBJECT_TYPE of USER ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. The user-supplied expression is evaluated each time a ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...It ... SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A user variable referenced by a statement in a stored procedure has its type ... A ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. (Bug #37621360) Installation Notes Debian packages for installing MySQL can now be run by users other than root. (Bug #37478594) InnoDB: Creating a secondary index ...Compilation Notes Configuration Notes InnoDB Notes Installation Notes Packaging Notes Functionality Added or Changed Bugs Fixed Compilation Notes macOS: It is now possible to compile the server on MacOS using ...
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/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]) ...