Search Results
https://dev.mysql.com/doc/refman/8.4/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage engine. Which versions of the MySQL software support NDB Cluster? Do I have to compile from source? A.10.2. What is the difference ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym ...
https://dev.mysql.com/doc/refman/8.4/en/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Expressions can be written using values ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the group. When this is done, the current primary becomes a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a server. When state transfer from the donor's binary ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned issues. As long as the ...