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/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/character-arrays.html
Binary collations need no <map> element because the character codes themselves provide the ordering. Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from numeric byte values). The binary character set is the character set for binary strings, which are ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
In terms of table content, conversion from utf8mb3 to utf8mb4 presents no problems: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, same length. This section describes issues that ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb4.html
utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, ... The utf8mb4 character set has these characteristics: Supports BMP and supplementary ...
https://dev.mysql.com/doc/refman/8.0/en/charset-we-sets.html
This means it is the same as the official ISO 8859-1 or IANA (Internet Assigned Numbers Authority) latin1, except that IANA latin1 treats the code points between 0x80 and 0x9f as “undefined,” whereas cp1252, and therefore MySQL's latin1, assign ... Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and ...
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 ...