CLEAR HINT

Description

The CLEAR HINT syntax is used to clear hint settings for current connection.

Syntax

  1. ClearHint ::=
  2.   'CLEAR' ('SHARDING'|'READWRITE_SPLITTING')? 'HINT'

Supplement

  • When SHARDING/READWRITE_SPLITTING is not specified, the default is clear all hint settings.

Example

  • Clear hint settings of sharding
  1. CLEAR SHARDING HINT;
  • Clear hint settings of readwrite splitting
  1. CLEAR READWRITE_SPLITTING HINT;
  • Clear all hint settings
  1. CLEAR HINT;

Reserved word

CLEAR, SHARDING, READWRITE_SPLITTING, HINT