PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html
TRUNCATE TABLE can be used with Performance Schema summary tables, but the effect is to reset the summary columns to 0 or NULL, not to remove rows. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
If a numeric expression contains any strings, they are converted to double-precision floating-point values and the expression is approximate. For inserts of strings into numeric columns, conversion from string to number is handled as follows if the ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. The union of two GTID sets is simply their representations as strings, joined together with an interposed comma. The GTID sets used ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
binary: Any kind of binary string argument, including a hexadecimal literal, bit literal, or NULL literal. nonliteral_binary: An argument that is a binary string value other than a hexadecimal literal, bit literal, or NULL literal. mysql> SELECT 5 & ... Table 12.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
The expression is unknown (that is, NULL) if table t2 contains (NULL,NULL,NULL). The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
row *************************** id: 1 select_type: PRIMARY table: t1 type: index possible_keys: NULL key: PRIMARY key_len: 4 ref: NULL rows: 4 filtered: 100.00 Extra: Using index *************************** 2. row *************************** id: 2 ... For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `id` int(11) DEFAULT NULL, KEY `id_index` (`id`) COMMENT 'MERGE_THRESHOLD=40' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Note A MERGE_THRESHOLD value defined at the index level ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...