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 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/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
build_timestamp: number A timestamp indicating when the model was created (UNIX epoch time). The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
The server does not create threads to handle interfaces that it does not listen to. For example, a Windows server that does not have support for named-pipe connections enabled does not create a thread to handle them. Manager threads create a new ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...