DROP CONCURRENT_LIMITING_RULE

Purpose

This statement is used to delete a throttling rule.

Privilege requirements

To execute the DROP CONCURRENT_LIMITING_RULE statement, the current user must have the DROP privilege. For more information about the privileges of OceanBase Database, see Privilege types in MySQL mode.

Syntax

DROP CONCURRENT_LIMITING_RULE [ IF EXISTS ] `ccl_rule_name1` [, `ccl_rule_name2`, ...]

Here, ccl_rule_name specifies the name of the throttling rule.

Examples

Execute the following statement to delete the throttling rules sql1_keywords_ccl_rule and sql2_keywords_ccl_rule.

obclient> DROP ONCURRENT_LIMITING_RULE `sql1_keywords_ccl_rule`,`sql2_keywords_ccl_rule`;