ALTER DEFAULT SHARDING STRATEGY
- When using the complex sharding algorithm, multiple sharding columns need to be specified using
SHARDING_COLUMNS
;
- Alter a default sharding table strategy
ALTER DEFAULT SHARDING TABLE STRATEGY (
TYPE="standard", SHARDING_COLUMN=user_id, SHARDING_ALGORITHM(TYPE(NAME="inline", PROPERTIES("algorithm-expression"="t_order_${user_id % 2}")))