https://dev.mysql.com/audit-log-filtering.html
To assign a different filter to the user account: SELECT audit_log_filter_set_filter('log_nothing', '{ "filter": { "log": false } }'); SELECT audit_log_filter_set_user('user1@localhost', 'log_nothing'); Filtering of current sessions for the account ... Note This section describes how audit log filtering works if the audit log plugin and the accompanying audit tables and UDFs are ...
https://dev.mysql.com/audit-log-reference.html
Example: mysql> SET @f = '{ "filter": { "log": false } }'; mysql> SELECT audit_log_filter_set_filter('SomeFilter', @f); +-----------------------------------------------+ | audit_log_filter_set_filter('SomeFilter', @f) | ...Unless those components ...
https://dev.mysql.com/c-api-data-structures.html
my_bool A boolean type, for values that are true (nonzero) or false (zero). This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream interface. For information ...
https://dev.mysql.com/case.html
This syntax cannot be used to test for equality with NULL because NULL = NULL is false. CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE Or: CASE WHEN search_condition THEN ...
https://dev.mysql.com/constant-folding-optimization.html
For = and <> comparisons, fold to TRUE, FALSE, or IS [NOT] NULL as described previously; for other operators, adjust the operator. Comparisons between constants and column values in which the constant value is out of range or of the wrong type with ...
https://dev.mysql.com/control-flow-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE expr described here differs slightly ...
https://dev.mysql.com/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals The following grammar ...
https://dev.mysql.com/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. What problems should I be aware of when working with the Big5 ...
