PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-digests.html
Both statements yield the same normalized form and thus are considered “the same”: SELECT * FROM orders WHERE customer_id = ? AND quantity > ? The normalized statement contains less information but is still representative of the original ... The ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-authentication.html
In the case that an account uses an authentication method that is the default for both the server and the client program, the server need not communicate to the client which client-side plugin to use, and a round trip in client/server negotiation ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
If both operands of a binary arithmetic operator are parameters, the type of the parameters is decided by the context of the operator. (In this case, an implicit CAST(? AS derived_type) is performed.) The derived type and actual type of the ...
https://dev.mysql.com/doc/refman/9.7/en/replace.html
To use REPLACE, you must have both the INSERT and DELETE privileges for the table. REPLACE supports explicit partition selection using the PARTITION clause with a list of comma-separated names of partitions, subpartitions, or both. REPLACE ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-table-options.html
When viewed in terms of events, the process of checking table options is the same for both row-based and statement-based replication. Note Statement-based replication stops if a single SQL statement operates on both a table that is included by a ...
https://dev.mysql.com/doc/refman/9.7/en/resource-groups.html
The default priority is 0, for both system and user groups. MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources ...
https://dev.mysql.com/doc/refman/9.7/en/roles.html
This enables assignment of sets of privileges to accounts and provides a convenient alternative to granting individual privileges, both for conceptualizing desired privilege assignments and implementing them. (It is permitted to assign both ...Like ...
https://dev.mysql.com/doc/refman/9.7/en/set-operations.html
Set operations work the same way when one or more TABLE statements, VALUES statements, or both, are used to generate the set. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-object-shapes.html
If both g1 and g2 are of dimension 1: If the lines cross each other in a finite number of points (that is, no common line segments, only single points in common). ST_Touches() handles its arguments as described in the introduction to this section ...