PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
Given two points pt1 and pt2, ST_MakeEnvelope() creates the result geometry on an abstract plane like this: If pt1 and pt2 are equal, the result is the point pt1. According to Boost.Geometry, geometries might become invalid as a result of the ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
The string might be shorter than max_length characters because the algorithm that creates the geohash value continues until it has created a string that is either an exact representation of the location or max_length characters, whichever comes ...
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
Suppose that an administrator has created the following role to confer the ability to set restricted session system variables: CREATE ROLE set_session_sysvars; GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO set_session_sysvars; Any user granted the ...(For ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
Version Tokens permit server access to be managed according to assignment without requiring clients to repeatedly query the servers about their assignments: The management application performs server assignments and establishes version tokens on ...
https://dev.mysql.com/doc/refman/8.0/en/windows-and-ssh.html
Log in to your server with the SSH session you just created. Create a new file in Windows and link to MySQL using the ODBC driver the same way you normally do, except type in localhost for the MySQL host server, not yourmysqlservername. This ...
https://dev.mysql.com/doc/refman/8.0/en/administrative-connection-interface.html
As mentioned in Connection Volume Management, to allow for the need to perform administrative operations even when max_connections connections are already established on the interfaces used for ordinary connections, the MySQL server permits a ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/8.0/en/case.html
(The indentation used here in the ELSE clause is for purposes of clarity only, and is not otherwise significant.) DELIMITER | CREATE PROCEDURE p() BEGIN DECLARE v INT DEFAULT 1; CASE v WHEN 2 THEN SELECT v; WHEN 3 THEN SELECT 0; ELSE BEGIN END; END ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-server.html
The server character set and collation are used as default values if the database character set and collation are not specified in CREATE DATABASE statements. MySQL Server has a server character set and a server collation. By default, these are ...