©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
This website works better with Javascript
The MyWAY SQL Manager can be downloaded here for free: as PHP installation file as GZIP file as ZIP archive
If the download from this page does not work, you can also download the program here (Virus checked at heise.de).
By downloading you accept the General Terms and Conditions
The program MyWAY SQL-Manager only works with Javascript
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: 2025-11-04ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedin©2020-2025 Heino Cunze-Fischer