tencent cloud

create table t1 (
  a bigint unsigned not null  PRIMARY KEY,
  b varchar(16) not null,
  pad varchar(128) not null,
  key key_b(b) global   -- Add the `global` keyword to specify a global index during table creation.
)
PARTITION BY RANGE(a) (
  PARTITION p0 VALUES LESS THAN (10000000),
  PARTITION p1 VALUES LESS THAN (20000000),
  PARTITION p2 VALUES LESS THAN (30000000),
  PARTITION p3 VALUES LESS THAN (MAXVALUE)
);

create index key_b on t1(b) global; -- Add the `global` keyword to specify a global index during index creation.
alter table t1 add index key_b(b) global;