PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-mbr.html
The return values 1 and 0 indicate true and false, respectively. If any argument is geometrically invalid, either the result is true or false (it is undefined which), or an error occurs. MySQL provides several MySQL-specific functions that test the ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/string-comparison-functions.html
The same is true for aggregate queries involving NULL and comparisons using NOT RLIKE or NOT REGEXP. Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
The “pushdown” strategy just described works if either of these conditions is true: outer_expr and inner_expr cannot be NULL. AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X when the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...
https://dev.mysql.com/doc/refman/8.0/en/administrative-connection-interface.html
This is true even if administrative TLS parameters have nondefault values because disabling --admin-ssl takes precedence. As mentioned in Connection Volume Management, to allow for the need to perform administrative operations even when ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
This is true for both ALTER EVENT and CREATE EVENT statements. ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO ...