ADD SHARDING HINT DATABASE_VALUE

Description

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

Syntax

  1. AddShardingHintDatabaseValue ::=
  2.   'ADD' 'SHARDING' 'HINT' 'DATABASE_VALUE' shardingHintDatabaseValueDefination
  4.   shardingHintDatabaseValueDefination ::=
  5.     tableName '=' databaseShardingValue
  7.   tableName ::=
  8.     identifier
  10.   databaseShardingValue ::=
  11.     int

Example

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

Reserved word

ADD, SHARDING, HINT, DATABASE_VALUE