PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
For each server, you should pick a unique positive integer in the range from 1 to 232 − 1, and each ID must be different from every other ID in use by any other source or replica in the replication topology. Both variables have global and session ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
margin1: A nonnegative integer that specifies the number of characters on the left end of the string to remain unmasked. margin2: A nonnegative integer that specifies the number of characters on the right end of the string to remain unmasked.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. Note The daemon_memcached plugin supports inserts and reads on mapped InnoDB tables that ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. This optional display width may be used by applications to display integer values having a width ...For example, INT(4) specifies an INT with a display width of four ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
margin1: A nonnegative integer that specifies the number of characters on the left end of the string to remain unmasked. margin2: A nonnegative integer that specifies the number of characters on the right end of the string to remain unmasked. Prior ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
Requires --restore-data ADDED: NDB 8.0.29 --allow-pk-changes Command-Line Format --allow-pk-changes[=0|1] Introduced 8.0.21-ndb-8.0.21 Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 When this option is set to 1, ndb_restore allows the ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
validate_password.length Command-Line Format --validate-password.length=# System Variable validate_password.length Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 8 Minimum Value 0 The minimum number of characters that ...