PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
ALL_SIGNED Treat promoted integer types as signed values (the default behavior). ALL_SIGNED,ALL_UNSIGNED Treat promoted integer types as signed if possible, otherwise as unsigned. When an integer type is promoted, its signedness is not preserved.
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
NO_UNSIGNED_SUBTRACTION Subtraction between integer values, where one is of type UNSIGNED, produces an unsigned result by default. An example of when the default is to produce a warning is inserting a value of the wrong data type into a column (such ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
For functions that take length arguments, noninteger arguments are rounded to the nearest integer. [USING charset_name]) CHAR() interprets each argument N as an integer and returns a string consisting of the characters given by the code values of ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
WKB uses 1-byte unsigned integers, 4-byte unsigned integers, and 8-byte double-precision numbers (IEEE 754 format). Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
If the AUTO_INCREMENT value becomes larger than the maximum integer for the specified integer type In all lock modes (0, 1, and 2), the behavior of the auto-increment mechanism is undefined if the value becomes larger than the maximum integer that ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-redo-log-reader.html
# is an integer in the range 0 to 15, inclusive. Command-Line Format -page # Type Integer Default Value 0 Minimum Value 0 Maximum Value 31 -page #: Start at this page. # is an integer in the range 0 to 31, inclusive. Command-Line Format -pageindex # ... Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-show-tables.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/8.0/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Exact-value numeric literals have an integer part or fractional part, or both. An integer may be used in floating-point context; it ...Numbers may be preceded by - or + to indicate a negative or positive value, ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. This can simply be the name of a column whose type is one ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. The expression is exact and is evaluated using integer arithmetic and has a ...