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/partitioning-columns.html
In addition, both RANGE COLUMNS partitioning and LIST COLUMNS partitioning support the use of non-integer columns for defining value ranges or list members. The permitted data types are shown in the following list: All integer types: TINYINT, ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
In the case of RANGE, LIST, and [LINEAR] HASH partitioning, the value of the partitioning column is passed to the partitioning function, which returns an integer value representing the number of the partition in which that particular record should ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
MAXVALUE represents an integer value that is always greater than the largest possible integer value (in mathematical language, it serves as a least upper bound). A table that is partitioned by range is partitioned in such a way that each partition ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. Exact-value numeric literals have an integer part or fractional part, or both.
https://dev.mysql.com/doc/refman/8.0/en/select.html
LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants, with these exceptions: Within prepared statements, LIMIT parameters can be specified using ? placeholder markers. Within stored programs, LIMIT parameters ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
For example, in NDB tables, the TINYINT, SMALLINT, MEDIUMINT, and INTEGER (INT) column types each require 4 bytes storage per record due to the alignment factor. Storage for the integer and fractional parts of each value are determined separately.
https://dev.mysql.com/doc/refman/8.0/en/sys-quote-identifier.html
Example mysql> SELECT sys.quote_identifier('plain'); +-------------------------------+ | sys.quote_identifier('plain') | +-------------------------------+ | `plain` | +-------------------------------+ mysql> SELECT sys.quote_identifier('trick`ier'); ... Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL ...
https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html
For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary.
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the ... Data type specifications can have explicit or implicit default ...