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/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/9.7/en/create-json-duality-view.html
The optional json_constructor_null_clause specifies the behavior of this function when json_duality_object_expression evaluates to null. It takes either of the values ABSENT ON NULL or NULL ON NULL (the default). NULL ON NULL returns the JSON null ... CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY {DEFINER | INVOKER}] JSON [RELATIONAL] DUALITY VIEW [IF NOT EXISTS] [schema_name.]view_name AS json_duality_select_statement json_duality_select_statement: SELECT json_duality_object_expression FROM [schema_name.]root_table_name [AS table_alias] json_duality_object_expression: JSON_DUALITY_OBJECT(...) This statement creates a JSON duality view named ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 | ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-functions.html
mysql> SELECT PS_CURRENT_THREAD_ID(); +------------------------+ | PS_CURRENT_THREAD_ID() | +------------------------+ | 52 | +------------------------+ mysql> SELECT PS_THREAD_ID(CONNECTION_ID()); +-------------------------------+ | ... MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL, PRIMARY KEY (`NAME`) ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 ... This ...
https://dev.mysql.com/doc/refman/9.7/en/regexp.html
If expr or pat is NULL, the return value is NULL. If expr or pat is NULL, the return value is NULL. If expr or pat is NULL, the return value is NULL. If expr, pat, or repl is NULL, the return value is NULL. If expr or pat is NULL, the return value ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/9.7/en/show-columns.html
Collation The collation for nonbinary string columns, or NULL for other columns. 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 tell whether the column permits NULL ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/refman/9.7/en/show-processlist.html
row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: Waiting for source to send event Info: NULL *************************** 2. row *************************** Id: 2 User: system user Host: db: ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...