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/data-masking-component-functions.html
Each country can have a different national routing or account numbering system, with a minimum of 13 and a maximum of 34 alphanumeric ASCII characters. When possible, generated values have characteristics reserved for demonstration or test values, ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. If the resulting table would have an expression default value that contains a forward reference to a generated column or column with an expression default value, the statement ...A DEFAULT value clause in a data type specification explicitly indicates a default value for a ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
Each CTE reference in the top-level statement can have its own hint, permitting CTE references to be selectively merged or materialized. The optimizer handles derived tables, view references, and common table expressions the same way: It avoids ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
Striping Striping means that you have many disks and put the first block on the first disk, the second block on the second disk, and the N-th block on the (N MOD number_of_disks) disk, and so on. You have to choose to optimize for random or ... This ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
It demonstrates that you can use mysql as a simple calculator: mysql> SELECT SIN(PI()/4), (4+1)*5; +------------------+---------+ | SIN(PI()/4) | (4+1)*5 | +------------------+---------+ | 0.70710678118655 | 25 | +------------------+---------+ 1 row ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
Typically, a sink processes log events into log messages that have a particular format and writes these messages to its associated output, such as a file or the system log. Also remove any associated component variables settings that you have ... In ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? A.1.7. The auto_increment_increment value should be greater than the number of servers, and each server should have a unique offset. Does MySQL have a NOW() function with fractions 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. (InnoDB does not have an equivalent setting.) This variable can be changed while the server ...Modifying the default behavior in most cases can actually decrease ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
False hits or misses might occur for stopword lookups if the stopword file or columns used for full-text indexing or searches have a character set or collation different from character_set_server or collation_server. The stopword table must have a ... The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
For Group Replication, note the following key points and differences: The donor (an existing group member) and the recipient (the joining member) must have the clone plugin installed and active. The donor and the recipient must have the Group ...If ...