Search Results
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-functions.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. When the variable is set to OFF, content encrypted by the legacy functions cannot be decrypted, and the function returns ... MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-status-system-variables.html
For example: static int my_foo; static MYSQL_SYSVAR_INT(foo_var, my_foo, PLUGIN_VAR_RQCMDARG, "foo comment", NULL, NULL, 0, 0, INT_MAX, 0); ... For example: static MYSQL_THDVAR_BOOL(some_flag, PLUGIN_VAR_NOCMDARG, "flag comment", NULL, NULL, FALSE); ... The server plugin interface enables plugins to expose status and system variables using the status_vars and system_vars members of the general plugin ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb-cluster-connection.html
Signature const Ndb* get_next_ndb_object ( const Ndb* p ) Parameters This method takes a single parameter, a pointer to the last Ndb object to have been retrieved or NULL. Return value Returns the next Ndb object, or NULL if no more Ndb objects are ... This section provides information about the Ndb_cluster_connection class, which models a connection by a management server (ndb_mgmd) to a set of data ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-modify.html
The modify(SearchConditionStr) function is for modifying documents in a collection, similar to an UPDATE statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that are to be ...
https://dev.mysql.com/doc/refman/8.4/en/gis-linestring-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_IsClosed() returns 0 if ls is not closed, and NULL ...You can extract particular points of a LineString, count the number of points that it contains, or obtain its ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented.
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
The Schema Privileges panel has the following sections, used to create users for your schemas and to define roles: Users Roles The following figure displays the Schema Privileges section of the MySQL Model tab. Figure 9.7 Roles and Privileges ...