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

  1. AddShardingHintDatabaseValue ::=
  2.   'ADD' 'SHARDING' 'HINT' 'TABLE_VALUE' shardingHintTableValueDefination
  4.   shardingHintTableValueDefination ::=
  5.     tableName '=' tableShardingValue
  7.   tableName ::=
  8.     identifier
  10.   tableShardingValue ::=
  11.     int

Example

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

Reserved word

ADD, SHARDING, HINT, TABLE_VALUE