Retro Eye care Haitian Deep Dark Default

ADD SHARDING HINT TABLE_VALUE

Description

The ADD SHARDING HINT TABLE_VALUE syntax is used to add table sharding value to specified table for current connection.

Syntax

AddShardingHintDatabaseValue ::=
  'ADD' 'SHARDING' 'HINT' 'TABLE_VALUE' shardingHintTableValueDefination
  
  shardingHintTableValueDefination ::=
    tableName '=' tableShardingValue

  tableName ::=
    identifier

  tableShardingValue ::=
    int

Example

  • Add the table sharding value for specified table
ADD SHARDING HINT TABLE_VALUE t_order = 100;

Reserved word

ADD, SHARDING, HINT, TABLE_VALUE