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/numeric-types.html
These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED ...MySQL treats DOUBLE as a synonym for DOUBLE PRECISION (a nonstandard ...
https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html
These mappings make it easier to import table definitions from other database systems into MySQL. To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. If you create ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html
All of these columns are taken into account both for the purpose of placing rows in partitions and for the determination of which partitions are to be checked for matching rows in partition pruning. In addition, both RANGE COLUMNS partitioning and ... The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html
Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the INT types or DECIMAL. This section discusses limitations in MySQL Partitioning relating specifically to functions used in ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management.html
For a discussion of performing maintenance operations on partitions, see Section 26.3.4, “Maintenance of Partitions”. changes only the storage engine used by the table, and leaves the table's partitioning scheme intact. There are a number of ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-pruning.html
Pruning can also be applied to short ranges, which the optimizer can convert into equivalent lists of values. When a table is partitioned by HASH or [LINEAR] KEY, pruning can be used only on integer columns. For example, this statement cannot use ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. The function may consist of any expression valid in MySQL that ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-optimization.html
This implementation provides two important benefits: It entirely avoids the maintenance cost normally incurred for tables that undergo frequent updates. Applications that monitor databases may make frequent use of Performance Schema tables. To ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-user-defined-functions-table.html
The value is one of int, decimal, real, char, or row. The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. For information about ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL statement may not be the same as the value represented internally. Attempts to treat ...The ...