Purpose
This function (expression) is used to delete a filter.
Syntax
AUDIT_LOG_FILTER_REMOVE_FILTER('filter_name');
Description
Parameters
filter_name: the name of the filter.
Note
AUDIT_LOG_FILTER_REMOVE_FILTER has the semantics of DROP IF EXISTS. Dropping non-existent objects will not cause an error.
Return value
The expression input must be a string constant, and the output is of the string type.
- When DDL is executed successfully, the expression returns
OK. - When DDL execution fails, the
SELECTstatement is still executed successfully, and the expression outputs an error message.
Examples
Delete the log_all filter.
SELECT AUDIT_LOG_FILTER_REMOVE_FILTER('log_all');
The return result is as follows:
+-------------------------------------------+
| AUDIT_LOG_FILTER_REMOVE_FILTER('log_all') |
+-------------------------------------------+
| OK |
+-------------------------------------------+
1 row in set