Retro Eye care Haitian Deep Dark Default

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

AddShardingHintDatabaseValue ::=
  'ADD' 'SHARDING' 'HINT' 'DATABASE_VALUE' shardingHintDatabaseValueDefinition
  
  shardingHintDatabaseValueDefinition ::=
    tableName '=' databaseShardingValue

  tableName ::=
    identifier

  databaseShardingValue ::=
    int

Example

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

Reserved word

ADD, SHARDING, HINT, DATABASE_VALUE