©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Create MySQL, MariaDB table partitions

Creating MySQL and MariaDB table partitions

MySQL - Partitions Partitioning is part of table editing
MySQL - Creating partitions
Module for creating partitions of a MySQL or MariaDB table:

The type of partitioning can be chosen:

Partitioning by: Choice of partitioning method.
Expression: Expression or table field by which to partition.
Number of partitions: Number of partitions to create.
Start: Start the partition editor with the parameters.
Create partitions Partitions are created.
Show SQL statement Show SQL statement of partition creation.
Partitioning methods:
HASH: Partitioning by return value of an expression or table column that operates on the column values ​​of the data rows.
The expression must result in a positive integer value.
LINEAR HASH: Like HASH, except that the partition assignment is derived as a power of two instead of modulo.
KEY: Partitioning by one or more table columns.
If no table column is specified, the primary key is used for partitioning.
LINEAR KEY:Like KEY, except that the partition assignment is derived as a power of two instead of modulo.
RANGE: Partitioning by column or expression values ​​that matches within a defined range of values.
RANGE COLUMNS: Partitioning by multiple column or expression values ​​that matches within multiple defined value ranges.
LIST: Partitioning by column or expression values matches ​​within defined value lists.
LIST COLUMNS: Partitioning by multiple column or expression values ​​that matches into multiple defined lists of values.
SYSTEM_TIME: Only MariaDB: Partitioning of system-versioned tables.
SYSTEM_TIME INTERVAL: Only MariaDB: Partitioning of system-versioned tables with specification of the interval.
More information about creating partitions in MySQL tables: mysql.com and mariadb.com
Updated: 2023-09-15ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer