PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-object-shapes.html
The return values 1 and 0 indicate true and false, respectively, except that distance functions return distance values. If any geometry argument is geometrically invalid, either the result is true or false (it is undefined which), or an error occurs. The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data types. The data types are listed here: Integer: All variants and aliases of MySQL integer data types are supported, including TINYINT, ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-table.html
The Table object represents a database table existsInDatabase(): Returns true if the table exists in the current database, otherwise false. isView(): Returns true if the table is a view, otherwise false. count(): Returns the number of rows in this ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/9.7/en/all-subqueries.html
The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The ...
https://dev.mysql.com/doc/refman/9.7/en/any-in-some-subqueries.html
The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is unknown (that is, NULL) if table t2 ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-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 For audit log filtering to work as described here, the audit log component and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-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) | ...Audit Log Tables MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/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 ... Important The audit_log plugin is deprecated, and is being replaced by the audit_log ...
https://dev.mysql.com/doc/refman/9.7/en/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) | ... Important The audit_log ...