Search Results
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
If the SQL thread is in the middle of a transaction at this point, the server waits until the current replication event group (if any) has finished executing, or until the user issues a KILL QUERY or KILL CONNECTION statement. The server shutdown ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
For Group Replication, the group_replication_recovery_get_public_key system variable serves the same purpose. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
Note MySQL 8.4 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a Solaris ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where those function descriptions occur. Spatial values, or geometries, have the properties described in ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
It has the name (SRS_NAME) WGS 84 and the ID (SRS_ID) 4326, which is the ID used by the European Petroleum Survey Group (EPSG). A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
Merge: Enables a MySQL DBA or developer to logically group a series of identical MyISAM tables and reference them as one object. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
A subquery can contain many of the keywords or clauses that an ordinary SELECT can contain: DISTINCT, GROUP BY, ORDER BY, LIMIT, joins, index hints, UNION constructs, comments, functions, and so on. All subquery forms and operations that the SQL ...