PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/grant-tables.html
The value is non-NULL only for accounts that use a MySQL built-in authentication plugin (sha256_password or caching_sha2_password). The value is NULL for other accounts, such as those authenticated using an external authentication system. If the ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-columns-table.html
This is NULL if the column has an explicit default of NULL, or if the column definition includes no DEFAULT clause. The value is YES if NULL values can be stored in the column, NO if not. (A UNIQUE index permits multiple NULL values, but you can ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-buffer-pool-tables.html
Example 17.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate count of pages that contain system data by excluding pages where the TABLE_NAME value is either NULL or includes a slash / or period . The InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-requirements.html
Attempting to insert NULL or an empty object is rejected with an error. This includes NULL, primary key, unique Key, check, and foreign key constraints. In such cases, either the column's default value, if applicable, or NULL is stored in those ...
https://dev.mysql.com/doc/refman/9.7/en/json-utility-functions.html
For a JSON column which has been updated such that its binary representation is the same as or larger than before, or if the update was not able to take advantage of a partial update, it returns 0; it returns NULL if the argument is NULL. If ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-service.html
If there is no user context, this value can be NULL. Syntax: bool my_key_fetch(const char *key_id, const char **key_type, const char* user_id, void **key, size_t *key_len) Arguments: key_id, user_id: Null-terminated strings that as a pair form a ...
https://dev.mysql.com/doc/refman/9.7/en/limit-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: 100.00 Extra: Using index condition; Using filesort See also Section 10.9.2, ... If you ...
https://dev.mysql.com/doc/refman/9.7/en/locking-service.html
Namespace and lock names must be non-NULL, nonempty, and have a maximum length of 64 characters. A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error.
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-table-info.html
uint24 NULL 0 1024 Field Start Length Nullpos Nullbit Type 1 1 1 2 2 4 no zeros 3 6 81 varchar 4 87 81 varchar 5 168 3 1 1 no zeros 6 171 3 1 2 no zeros Explanations for the types of information myisamchk produces are given here. Nullpos, Nullbit ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-config.html
This example demonstrates combining --config-binary-file with other ndb_config options to obtain useful output: $> ndb_config --config-binary-file=../mysql-cluster/ndb_50_config.bin.1 --diff-default --type=ndbd config of [DB] node id 5 that is ...