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 ...
