PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns-range.html
In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. As stated ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/performance-schema-variables-metadata-table.html
DATA_TYPE The variable's type; this is one of the following values: Integer An integer. row *************************** VARIABLE_NAME: innodb_doublewrite_batch_size VARIABLE_SCOPE: GLOBAL DATA_TYPE: Integer MIN_VALUE: 0 MAX_VALUE: 256 DOCUMENTATION: ... The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/srjsapi-session.html
sql(String sql, {passResultToClient: Bool, charsetName: String, integerType: IntegerType, decimalType: DecimalType}): Executes a simple SQL statement. IntegerType consists of a JSON key-value pair whose key is IntegerType, and whose possible values ... The Session object is always available as the session property of the global ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...