Search Results
https://dev.mysql.com/doc/refman/8.4/en/conditions-and-parameters.html
If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler).
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
shell.unparseUri() converts a dictionary of URI components and connection options into a valid URI-like connection string for connecting to MySQL, which can be used in MySQL Shell or by MySQL Connectors which implement X DevAPI. This section ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
Determination of the applicable user name and host name takes proxying into account and occurs as follows: If the client user proxies another user, the account for failed-connection counting is the proxying user, not the proxied user. This section ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html
The optimizer_search_depth variable tells how far into the “future” of each incomplete plan the optimizer should look to evaluate whether it should be expanded further. The task of the query optimizer is to find an optimal plan for executing an ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by dashes (aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee). The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
To create the RSA private and public key-pair files, run these commands while logged into the system account used to run the MySQL server so that the files are owned by that account: openssl genrsa -out private_key.pem 2048 openssl rsa -in ... This ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
In MySQL, a server-side cursor is materialized into an internal temporary table. Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
This is insecure; it is assumed that you intend to assign a password to the account in a timely fashion before putting the server into production use. After MySQL is installed, the data directory must be initialized, including the tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator character). Return value: ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-function-reference.html
Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions Name Description Deprecated gen_blacklist() Perform dictionary term replacement Yes gen_blocklist() Perform dictionary term replacement gen_dictionary_drop() Remove ...