Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
The column of the underlying table and the MERGE table can be NULL. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-store-result.html
mysql_store_result() returns NULL if the statement did not return a result set (for example, if it was an INSERT statement), or an error occurred and reading of the result set failed. (An empty result set differs from a null pointer as a return ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/partitioning-list.html
Note In MySQL 8.4, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when partitioning by LIST. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
Default value is NULL report_progress: specifies whether information such as routine progress detail is to be reported. The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
mysql> CREATE TABLE t2 (c1 VARCHAR(65533) NOT NULL) ENGINE = InnoDB CHARACTER SET latin1; Query OK, 0 rows affected (0.01 sec) For MyISAM tables, NULL columns require additional space in the row to record whether their values are NULL. Each NULL ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: j_idx key: j_idx key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using index condition mysql> EXPLAIN SELECT i, j FROM t1 WHERE j >= ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
If the key cannot be created, the return value is NULL and an error occurs. mysql> SELECT @x; +------+ | @x | +------+ | NULL | +------+ mysql> SELECT keyring_key_generate('x', 'AES', 16) INTO @x; mysql> SELECT @x; +------+ | @x | +------+ | 1 | ...