PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
Code the WHERE clause as WHERE MATCH(text) AGAINST ('other_text'), without any > 0 comparison operator. The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups ...
https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
row *************************** Level: Note Code: 1003 Message: /* select#1 */ select `test`.`t`.`ti` AS `ti` from `test`.`t` where (`test`.`t`.`ti` = 255) 1 row in set (0.00 sec) Floating- or fixed-point value. Comparisons between constants and ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
Issues with file-based metadata storage included expensive file scans, susceptibility to file system-related bugs, complex code for handling of replication and crash recovery failure states, and a lack of extensibility that made it difficult to add ... In previous MySQL releases, dictionary data was partially stored in metadata ...
https://dev.mysql.com/doc/refman/8.0/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. Its arguments are ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
For example, the world_x schema (installed later in this chapter) contains this document: { "GNP": 4834, "_id": "00005de917d80000000000000023", "Code": "BWA", "Name": "Botswana", "IndepYear": 1966, "geography": { "Region": "Southern Africa", ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
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 EXPLAIN. As of MySQL 8.0.12, extended information is available for SELECT, DELETE, ...
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 ...