No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysqlimport.html
The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Invoke mysqlimport like this: shell> mysqlimport [options] db_name textfile1 [textfile2 ...] For each text file named on the command line, mysqlimport strips ...Most options to mysqlimport correspond directly to clauses of LOAD DATA ...
https://dev.mysql.com/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/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/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/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/partitioning-management.html
For a discussion of performing maintenance operations on partitions, see Section 23.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/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/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/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/plugin-services.html
MySQL server plugins have access to server “plugin services.” The plugin services interface exposes server functionality that plugins can call. The interface includes a versioning mechanism so that service versions supported by the server can ...It complements the plugin API and has these characteristics: Services enable plugins to access code inside the server using ordinary function ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-int-p-29.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
