PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
For maximum portability, code requiring storage of approximate numeric data values should use FLOAT or DOUBLE PRECISION with no specification of precision or number of digits. The FLOAT and DOUBLE types represent approximate numeric data values.
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
For a complex character set such as Unicode, create collations using C source files that describe the character set properties. Change the value corresponding to 0x2D (which is the code for the '-' character) from 10 (punctuation) to 01 (uppercase ... Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code modifications. Modifying the default behavior in most cases can actually decrease effectiveness. Do not ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
The WKB type is a code that indicates the geometry type. Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
row *************************** Level: Note Code: 1276 Message: Field or reference 't3.t2.c1' of SELECT #2 was resolved in SELECT #1 Left outer join: mysql> EXPLAIN FORMAT=TREE SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1\G ... By default, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/history.html
This API was designed to enable third-party code that was written for use with mSQL to be ported easily for use with MySQL. We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
The POS value for a virtual generated column encodes the column sequence number and ordinal position of the column. PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
Each monitor represents a point within the InnoDB source code that is instrumented to gather counter information. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY WHERE CHARACTER_SET_NAME = 'utf8mb4'; +----------------------------+ | ...