13 lines
445 B
SQL
13 lines
445 B
SQL
/*!40014 SET FOREIGN_KEY_CHECKS=0*/;
|
|
/*!40101 SET NAMES binary*/;
|
|
CREATE TABLE `pt_case_2` (
|
|
`a` int DEFAULT NULL,
|
|
`b` int DEFAULT NULL,
|
|
UNIQUE KEY `idx` (`a`) /*T![global_index] GLOBAL */,
|
|
KEY `idx1` (`a`) /*T![global_index] GLOBAL */
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
|
|
PARTITION BY RANGE (`b`)
|
|
(PARTITION `p0` VALUES LESS THAN (4),
|
|
PARTITION `p1` VALUES LESS THAN (7),
|
|
PARTITION `p2` VALUES LESS THAN (11));
|